Formula help

  • Thread starter Thread starter Sasikiran
  • Start date Start date
S

Sasikiran

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
 
Assuming your source data as posted is within A2:C17
and your summary table is set up like this using adjacent cols to the right,
names in E2 down, eg: John, Mary, etc
letters in F1 across, eg: ABC, BCD, etc
Place this in F2, normal ENTER:
=INDEX($A$2:$A$17,MATCH(1,INDEX(($C$2:$C$17=$E2)*($B$2:$B$17=F$1),),0))
Copy F2 across/fill down to populate

Wave your success, click the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
Back
Top