You are viewing a single comment's thread from:

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

in #excel5 years ago

The text function that is needed in this case is called MID
The full formula that I used is =VLOOKUP(MID(A2,4,2)+0,$E$1:$F$7,2,FALSE)
- Kenroy Hunter

This comment was made by a guest account using @steempress. Rewards will be sent to the user once they have a Steem account

Coin Marketplace

STEEM 0.18
TRX 0.16
JST 0.029
BTC 63013.55
ETH 2460.64
USDT 1.00
SBD 2.64