Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a table that I return specific values when two conditions are true:
E H M L SI 700 600 500 400 DI 550 400 300 250 WM 550 400 300 200 BS NP 400 300 250 EB NP NP 250 250 For example, when two test are true, they return one of the values: i.e. if SI and E occur, return 700. If SI and H occur, return 600. I've tried the lookups, or, and, and several other functions, and can't seem to find one that allows me two variables to return a value. -- Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
Don't understand Lookup function | New Users to Excel | |||
lookup function 1 | Excel Worksheet Functions | |||
Lookup function problem (kg) | Excel Worksheet Functions |