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.16
TRX 0.24
JST 0.033
BTC 94866.41
ETH 2647.55
SBD 0.43