Need a search formula

[imnoexpert]

Hello-

I have a multi-column data table in which I need to perform a search. I am familiar with the vlookup function, but I am not sure how to apply it to my current issue. I would like to look up a value in column A and then if column B = a certain value and column C= a certain value, I want to result to be returned as yes in column D. See below

Column A Column B Column C Column D
Acct 1 $100 $75 yes
Acct 1 $75 $75 no
Acct 1 $100 $52.50 no
Acct 2 $82.93 $75 no
Acct 2 $100 $75 yes

In the above example if acct 1 is found and column B=100 and Column C=75, I want the result to be yes. In the formula, the values for B and C will be consistent for all searches. The only thing I would change is the acct number to look up. Any suggestions for how to do this. I am not well versed in excel so I thought someone at this forum would be able to assist me. Thank you.

 

[Domenic]

Assuming that A2:C6 contains the data, and D1 contains the account number of interest, try...

D2, copied down:

=IF(A2=D$1,IF(B2=100,IF(C2=75,"Yes","No"),"No"),"No")

Hope this helps!

xl-central.com