Match values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

plunk25 - 08 Mar 2007 00:31 GMT

I have 2 worksheets that are setup as follows:

wksht1:
column a = customer number
column b = customer name
column c = sales ytd

wksht2:
column a = customer number

What I need to do is pull the sales ytd from wksht1 and place it in wksheet
2 only if the customer number from wksht2 has a match in column a in wksht1.

I've tried a vlookup, but it doesn't quite do what I need it to. Can anyone
point me in the right direction?

Reply to this Message

Martin Fishlock - 08 Mar 2007 01:06 GMT

hi plunk:

the vlookup returns n/a on no match right?

so you can do the following:

=if(isna(vlookup(a2, wksht1!a:c, 3 false)),"",vlookup(a2, wksht1!a:c, 3
false))

or sum the sumif formula

=sumif(wksht1!a:a, a2,wksht1!c:c)

assuming the item is on row 2

Signature

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

> I have 2 worksheets that are setup as follows:
>
[quoted text clipped - 11 lines]
> I've tried a vlookup, but it doesn't quite do what I need it to. Can anyone
> point me in the right direction?

Reply to this Message