Forum Discussion
CANNOT SEE THE COLUMN IS IN WHICH ORDER
Hello, I am working with very big data by using VLOOKUP. While I am choosing the table array, I need to the small notification on the attached photo which I was able to before:....x5C, therefore ...
I don't know how to fix the row/column counter, but another option could be to use the columns function in the formula instead of counting the columns yourself. For example,
=VLOOKUP(G1,A1:E10,COLUMNS(A1:C1),FALSE)
=VLOOKUP(G1,A1:E10,COLUMNS(A1:C1),FALSE)