Thread: If ,AND, LOOKUP, Functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lot Doctor Lot Doctor is offline
external usenet poster
  
Posts: 1
Default 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.




Reply With QuoteReply With Quote