Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF function that searches a range of cells for data and provide tr | Excel Worksheet Functions | |||
How to update column info based on column info from another worksh | Excel Discussion (Misc queries) | |||
Function that searches cell for string? | Excel Worksheet Functions | |||
Getting valid web searches and avoiding sites that contaminate web searches | New Users to Excel | |||
Create a "recap" worksheet that includes all info from all worksh. | Excel Worksheet Functions |