Forum Discussion
vlookup column index number
when I use vlookup , and I want to fill in the column index, I no longer see numbers in the columns when I select the table array. It is difficult for me to count them, because sometimes it is column...
Do you have Microsoft 365 or Office 2021? If so, you can use XLOOKUP instead of VLOOKUP:
=XLOOKUP(lookup_value, column_to_search, column_to_return, if_not_found)
For example
=XLOOKUP(A2, $C$2:$C$100, $BD$2:$BD$100, "")
If you have an older version, you can use INDEX/MATCH:
=IFERROR(INDEX($BD$2:$BD$100, MATCH(A2, $C$2:$C$100, 0)), "")
We still have office Professional plus 2019 at work. We used to have 2016. Is it possible that Microsoft has made changes in the new version? My collegue still has the 2019 and the column numbers are visible (we use the same files for vlookup)
- no , it is not that. She also has letters in the columns, only when she select the range, numbers appear above each column.