Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula help
Hi Sasikiran
Try the below formula =INDEX($A$1:$A$100,MATCH(1,($B$1:$B$100="ABC")*($C $1:$C$100="John"),0)) (change to cell references to suit your requirement) If this post helps click Yes --------------- Jacob Skaria "Sasikiran" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula 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 --- "Sasikiran" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|