Can VLOOKUP Column_num return an answer from a colukn which is auto numbered?
Ive got a VLOOKUp to another sheet to work when the lookup_table is a single column, but when i extend the lookup_table to 6 columns, and the 'column-num' is 1, so left column of range, the formual doesnt work. It returns 'NO Match' when i know there is a match?
If i do a lookup_table range of just the column i need to find the search_value in, and enter 1 for column-num, then the formula works?
Help Article Resources
Check out the Formula Handbook template!