Forum Discussion
Pulling numbers from matching text cells
I have two columns of data (one text and the other numerical). I want to check a cell to see if the text in that cell matches the text in the first column (in a separate tab worksheet), and then have...
It looks like VLOOKUP is doing the trick for me.
Hi Malcolm
VLOOKUP will indeed do the trick
You could also consider using INDEX MATCH in the future (its a bit safer and a bit more flexible than VLOOKUP)
https://techcommunity.microsoft.com/t5/Formulas-and-Functions/INDEX-MATCH-the-easy-way/m-p/30256#M54