Thread: Searching on 2 columns and putting result in third column.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RobFJ[_3_] RobFJ[_3_] is offline
external usenet poster
  
Posts: 10
Default Searching on 2 columns and putting result in third column.
Columns B and C just contain either Yes, No.

Depending on the combination I want to put the text result in column C as
follows.


A B C

Yes Yes "Result 1"
Yes No "Result 2"
No Yes "Result 3"
No No "Result 4"


Can SKS help out as my formulae seem to be going more and more complex with
no correct result in sight :(

Tx

Reply With QuoteReply With Quote