| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to look up a cost but I need two criteria met Vlookup give.
I have a table and want to find One cost but it must meet two values. ie
Task number plus Labor = Cost or Task number plus material = Cost. Vlookup seams to only want to lookup one of the two values then return the cost |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I want to look up a cost but I need two criteria met Vlookup give.
You can accomodate VLOOKUP.
Say you have three columns: Task Material Cost and you need to specify both task and material to get cost. First create a new column and fill it by concatenating Task and Material. When you do the lookup, concatenate the values and VLOOKUP the merged inputs in the new column. This trick can be expanded to way more than 2 inputs. -- Gary's Student "Scott" wrote: I have a table and want to find One cost but it must meet two values. ie Task number plus Labor = Cost or Task number plus material = Cost. Vlookup seams to only want to lookup one of the two values then return the cost |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a total cost chart where a component cost is a step cost | Charts and Charting in Excel | |||
| Product of Hrs & minutes times rate per hr to give a cost | Excel Discussion (Misc queries) | |||
| Return cost with 2 criteria | Excel Worksheet Functions | |||
| Setting formula to give info from rows with certain criteria | Excel Worksheet Functions | |||
| Sum cost column based on date column and vlookup cost | Excel Programming | |||
Linear Mode
