Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If ,AND, LOOKUP, Functions
I would like to make a cell G37 come back with a number from checking IF
J37=1 and K2=1 Then LOOKUP FUNCTION But if J38=1 and K2=1 then LOOKUP different function. If J37=1 and K2=2 then LOOKUP different function IF J38=1 and K2=2 then LOOKUP different function. Even better yet I would like K2 to = N or E I hope you can help thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If ,AND, LOOKUP, Functions
Hi
Substituting N for 1 and E for 2 in your tests, can we assume that K2 will either be N or E? Can we also assume that J37 and J38 will never both be equal to 1 at the same time? If so, then =IF(K2="","", IF(AND(K2="N",J37=1),"lookup1", IF(AND(K2="N",J38=1),"lookup2", IF(AND(K2="E",J37=1),"lookup3","lookup4")))) Substitute your lookup formulae in place of the 4 Lookups (excluding the quotes) -- Regards Roger Govier "Lot Doctor" <Lot wrote in message ... I would like to make a cell G37 come back with a number from checking IF J37=1 and K2=1 Then LOOKUP FUNCTION But if J38=1 and K2=1 then LOOKUP different function. If J37=1 and K2=2 then LOOKUP different function IF J38=1 and K2=2 then LOOKUP different function. Even better yet I would like K2 to = N or E I hope you can help thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup and Sum Functions | Excel Discussion (Misc queries) | |||
Lookup functions | Excel Worksheet Functions | |||
help on lookup functions | Excel Worksheet Functions | |||
Lookup Functions | Excel Worksheet Functions | |||
Lookup Functions | Excel Worksheet Functions |