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 return the numerical data from the corresponding cell. (e.g., I have a column of 120 words and a matching column of 120 numbers in a worksheet. In a separate worksheet, I want to be able to type in any one of the words from the first column and have another cell auto-populate the corresponding number). Is that possible?
2 Replies
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
