Dear,

I need a formula to get the number appearing in column A if the text value
in column B & C is same as required.

Column A Column B Column C
134234 ABC John
253454 BCD John
234534 CDE John
453553 DEF John
345345 ABC Mary
453453 BCD Mary
3342342 CDE Mary
343543 DEF Mary
476566 ABC Peter
4564 67 BCD Peter
4534534 CDE Peter
3452342 DEF Peter
5766575 ABC Simon
564575 BCD Simon
345345 CDE Simon
23423 DEF Simon



ABC BCD CDE DEF
John =formula
Mary
Peter
Simon

Would require the corresponding number value in column A if the text value
in B &C columns is John & ABD.

Please help