Hi,

I have customer master codes in sheet 1, and customer codes and sales value
in sheet 2. I want to update sheet 1 with sales amounts from sheet 2, my
problem is that lookup is giving customers who do not appear in sheet 2 the
same sales value as the last customer code with sales value which makes me
manually delete amounts in these cells.
Illustration:
Sheet(1)
Customer Code Customer Name
12345 John
12346 James
12347 Joan
12348 Sam

Sheet (2)
Customer Code Sales Value ($)
12345 5,000
12346 1,500
12348 750

Sheet (1) after Lookup
Customer Code Customer Name Sales Value ($)
12345 John 5,000
12346 James 1,500
12347 Joan 1,500
12348 Sam 750
Sales value for 12347 is taken from 12346!

Is there any solution to this?

Thanks
--
tarig