MS Excel

1 post / 0 new
fefe0014
MS Excel

Does anyone know how to drag the cells containing a VLOOKUP function so that lookup_value changes but the table_array remains the same? For example, the code I am using in a cell is =IF(ISNA(VLOOKUP(B75,'C070'!B53:D348,3,FALSE)),"",VLOOKUP(B75,'Sheet 2'!B53:D348,3,FALSE)). I want all the B75's to change in relation to the row number when I select and drag, but I want everything else to stay the same.

   

Add new comment