Thread: Evaluate on multiple columns and return a value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Evaluate on multiple columns and return a value
Build a table with you 18 possible answers.

e.g. HighNoLOw One Possible Result
HighYesLow Another Result

Then, in column D lookup the result you want with a formula like this:

=VLOOKUP(A7&B7&C7,H4:I5,2,FALSE)

I hope that makes sense.

Tom
Reply With QuoteReply With Quote