Nov 09 2023 12:47 PM
Can someone explain to me why I can't use my entire table array for vlookup?
View best response
Nov 09 2023 03:11 PM
@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.
