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?

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
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"plunk25" wrote:

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?