Forum Discussion
Solved
Simple VLookup Question
Can someone explain to me why I can't use my entire table array for vlookup?
The lookup value in A7 is a number.
The cells in A15:A19 contain text values. They don't match a number. That's why you have to use B15:B19 - those cells contain numbers.
The lookup value in A7 is a number.
The cells in A15:A19 contain text values. They don't match a number. That's why you have to use B15:B19 - those cells contain numbers.