| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Values
Hello
I'm trying to lookup and return a value but based on two conditions being satisfied. I key a code into A21 and a Length into F21 and return a value from the lookup table. So: If A21 and F21 are found in the lookup table then return the value in R4:R158 Similarly, if A21 and H21 are found return the value. I've attached a piece of the spreadsheet that I hope will help explain Many thanks for taking the time Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| multiple series of values graphed with indep. x values -possible? | Charts and Charting in Excel | |||
Threaded Mode
