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