Simple VLookup Question

[QuinnM7]

Can someone explain to me why I can't use my entire table array for vlookup?

[#2 · Accepted solution]

@QuinnM7 

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.