Hi,
I'm stuck on retrieving col_index_num from another sheet. With table_array everything is ok, it looks in Sheet2, but I can't seem to take column from Sheet2, it always takes it from Sheet1).
Formula is in Sheet1:
=VLOOKUP(A1; Sheet2!B1:B114; 1; FALSE)
I want to take 1st column value where it finds that match from Sheet2
Thanks for your advice.
Bookmarks