FUNCTION THAT SEARCHES DATA AND RETURNS INFO ON A DIFFERENT WORKSH

I

indyjojo

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.
 
B

Bernie Deitrick

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

indyjojo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top