Forum Discussion
#ref error using If and Vlookup
I'm trying to use this formula with the IF and Vlookup =IF(H13>=@'[Job Status.xlsx]Sheet1'!$A$2:$A$1048576, VLOOKUP(H13,'[Job Status.xlsx]Sheet1'!$A$2:$A$1048576,2,),"") The idea is, if I put in th...
VLOOKUP(H13,'[Job Status.xlsx]Sheet1'!$A$2:$A$1048576,2,)
The table_array argument of your VLOOKUP refers to one column (A) and the col_index_num (2) argument tries to refer to the second column of the table_array. This is impossible and therefore the #REF! error is returned.
Have you considered working with XLOOKUP? If you are using Excel 2021 or more recent versions you can switch to XLOOKUP that offers many more possibilities.