Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup based on two criteria
I've read through many posts on this topic but I've not been able to
find a solution to my problem. On one tab I have six columns of information (table_array.) Column "A" contains a machine name, Column "B" contains a fault name and column "F" contains a time value (decimal minutes.) For each machine there may be any number of faults associated to it. I am trying to return the time value for a specific machine's fault name to a corresponding cell on another tab in the same worksheet. The lookup_value will come from another reference in the document; I can work through that but cannot resolve the two criteria requirement (machine and fault name) to pull in the time value. Any response is appreciated. KG |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup based on two criteria | Excel Discussion (Misc queries) | |||
How to retrieve a value based on 2 different criteria | Excel Worksheet Functions | |||
Add a row based on other criteria | Excel Worksheet Functions | |||
IF-based SUMPRODUCT criteria | Excel Discussion (Misc queries) | |||
Need help looking up value based on criteria | Excel Worksheet Functions |