Replacing duplicate information from one worksheet to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The first spreadsheet contains a stock item description with a cost, the second worksheets contains some of the stock items with new prices. I need to copy the new prices to the first sheet replacing any duplicate items.
 
Hi
not quite sure but maybe the following non VBA solution would work for
you:
- in the first sheet use a helper column (e.g. col. C) and enter the
following formula (assumption: col. A contains the stock item and col.
B the price) in C1
=IF(ISNA(VLOOKUP(A1,'sheet2'!$A$1:$B$200,2,0)),"no new
price",VLOOKUP(A1,'sheet2'!$A$1:$B$200,2,0))
and copy down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

move rows to another worksheet 1
Information from one sheet to another help please. 1
How to copy workbook and formulas to read to the present month 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel 2007 - combining worksheets to use for a mail merge 1
Copying related information between worksheets 2
Pick Price From Contract Info 4
I need to copy data from sht 1 to sht 2 according to specific crit 2

Back
Top