Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find match between 2 columns and then record data that is in colum
A B C D
UPCA UPCB INVENTORY RESULT 55 55 10 56 57 9 57 56 8 90 80 4 80 90 3 17 15 2 I need a formula that will find matches between column A+B then Record the data that is in Column C in D. B+C are related fields (fixed) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find match between 2 columns and then record data that is in colum
=IF(COUNTIF($A$2:$A$7,B2)0,C2)
and copy down -- HTH RP (remove nothere from the email address if mailing direct) "Karl" wrote in message ... A B C D UPCA UPCB INVENTORY RESULT 55 55 10 56 57 9 57 56 8 90 80 4 80 90 3 17 15 2 I need a formula that will find matches between column A+B then Record the data that is in Column C in D. B+C are related fields (fixed) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find match between 2 columns and then record data that is in c
Bob everything works except I need to add more to the formula. C2 needs to
actually represent C????. Or the C cell corresponding to the match in A. Right now the formula is find matches in A and B and then Recording C in numeric order. I need C to be wherever the A match is. C is always moving. so when B2 matches A15 I need C15 to be recorded not C2. I hope this is clear. thanks again "Bob Phillips" wrote: =IF(COUNTIF($A$2:$A$7,B2)0,C2) and copy down -- HTH RP (remove nothere from the email address if mailing direct) "Karl" wrote in message ... A B C D UPCA UPCB INVENTORY RESULT 55 55 10 56 57 9 57 56 8 90 80 4 80 90 3 17 15 2 I need a formula that will find matches between column A+B then Record the data that is in Column C in D. B+C are related fields (fixed) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find match between 2 columns and then record data that is in c
How about this then
=IF(NOT(ISNUMBER(MATCH(B2,A:A,0))),"",INDEX(A:A,MA TCH(B2,A:A,0))) -- HTH RP (remove nothere from the email address if mailing direct) "Karl" wrote in message ... Bob everything works except I need to add more to the formula. C2 needs to actually represent C????. Or the C cell corresponding to the match in A. Right now the formula is find matches in A and B and then Recording C in numeric order. I need C to be wherever the A match is. C is always moving. so when B2 matches A15 I need C15 to be recorded not C2. I hope this is clear. thanks again "Bob Phillips" wrote: =IF(COUNTIF($A$2:$A$7,B2)0,C2) and copy down -- HTH RP (remove nothere from the email address if mailing direct) "Karl" wrote in message ... A B C D UPCA UPCB INVENTORY RESULT 55 55 10 56 57 9 57 56 8 90 80 4 80 90 3 17 15 2 I need a formula that will find matches between column A+B then Record the data that is in Column C in D. B+C are related fields (fixed) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|