View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fire Guy Fire Guy is offline
external usenet poster
 
Posts: 2
Default Lookup or reference function needed

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.