Spreadsheet VLOOKUP

I always forget the syntax for VLOOKUP()

VLOOKUP(toLookUp, cellsToSearch, columnOffset)

Assuming we have a simple two column spreadsheet with the first column being clientName for example and the second column to be hourlyRate

AB
1Client One25
2Client Two50
3Client Three35

To get the Hourly rate of the whatever client you enter into a cell you would use; Cell D2 being the lookup cell, A1:B3 being the sells to look at and offset 2 being the column number in the array of cells to bring back

VLOOKUP(D2, A1:B3, 2)

Leave a comment

Your email address will not be published.