You are viewing a single comment's thread from:

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

in #excel6 years ago

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)
That was fun. The really cool part...I've used Text Functions for years and never knew that I could turn the result into a number by adding 0. I absolutely love learning new things!

Coin Marketplace

STEEM 0.17
TRX 0.24
JST 0.033
BTC 95224.32
ETH 2655.43
SBD 0.43