Sorry if this is just too obvious but I have always defined a Vlookup table_array using row and column coordinates. I was looking at a Vlookup formula in colleagues workbook and it defined only columns.
So instead of what I would normally consider using:
=VLOOKUP(A2,'sheet2'!$A$2:$G$100,2,FALSE)
they had simply defined the columns:
=VLOOKUP(A2,'sheet2'!A:G,2,FALSE)
I couldn't find any reference to using Vlookup like this so I wondered if this is something others use, or whether there could be issues doing it this way. Obviously this is an easier way to enter particularly on larger datasets where you can simply drag the columns to define the table array.
Bookmarks