Take a look in help at VLOOKUP, using the Truck # as the match value, and forcing an exact match
(False as the last parameter).

--
HTH,
Bernie
MS Excel MVP


"indyjojo" wrote in message
...
I have a worksheet that calculates pay for leased trucks. I currently have a
load sheet where I enter "truck 1", "truck 2", and "truck 3" (drop down list)
and the location they delivered to. I need the function to search the load
sheet and insert the location on a separate worksheet for that specific lease
truck. I have an if statement for truck 1's worksheet but if a line does not
contain "truck 1" it returns a zero. I would like the function to skip that
line if the data is not for truck 1. ANY help would be greatly appreciated.