RE: How to carry out a VLOOKUP within Text in Excel

You are viewing a single comment's thread from:

How to carry out a VLOOKUP within Text in Excel

in excel •  5 years ago 

Excel Learn and Earn Activity 6:
What text function is needed in this case?
MID
What is the full formula that you used?
=VLOOKUP(MID(A2,4,2)+0,$E$1:$F$7,2,FALSE)

excel
5 years ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$0.21
  • Past Payouts $0.21
  • - Author $0.10
  • - Curators $0.11
3 votes
0
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!