FUNCTION THAT SEARCHES DATA AND RETURNS INFO ON A DIFFERENT WORKSH
 

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.

FUNCTION THAT SEARCHES DATA AND RETURNS INFO ON A DIFFERENT WORKSH
 

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.

FUNCTION THAT SEARCHES DATA AND RETURNS INFO ON A DIFFERENT WO
 

Thanks for your assistance. I tried using the vlookup but it returns #N/A. I
have a sheet where I enter each load for all drivers. I need a function that
will search all rows and send the location name to truck 1's pay sheet. Maybe
what I need is not a function but a macro. Any help is appreciated.

"Bernie Deitrick" wrote:

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.


.