Hello,

I currently have a hlookup formula as follows in F4:

=HLOOKUP(B4&"3",$1:$500,2+M4,FALSE)

This formula is copied down over hundreds of rows, so the column index number in M4 becomes M5 then M6 etc, all of which have different values.

Now, as this is a large spreadsheet (60mb) I have been told that using Index Match is more efficient than Hlookup. However, I can't figure out how to do it as usually you select the row you want for the match array, and I want it to change on each row based on the value in M.

Firsty, is it true that Index Match would work better here, and if so can anyone tell me how to do it?

Thanks in advance.