How to reference entire columns in a VLOOKUP.

In a VLOOKUP you can reference the entire column for the table array to make your formula cleaner and easier to move between rows and columns without needing the $ absolutes for specific cell values. (This would be good when you do not have any data underneath your table that you would not want the vlookup to find.)

=VLOOKUP(E5,A:B,2,false)

Leave a comment