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)
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)
=IF(COUNTIF($A$2:$A$7,B2)>0,C2)
and copy down
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Karl" <[email protected]> wrote in message
news:[email protected]...
> 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)
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>
>
How about this then
=IF(NOT(ISNUMBER(MATCH(B2,A:A,0))),"",INDEX(A:A,MATCH(B2,A:A,0)))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Karl" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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)
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks