Update records from one spreadsheet to another

  • Thread starter Thread starter homevestors
  • Start date Start date
H

homevestors

Thanks for your response, but I do not understand what a "VLOOKUP" is.

Is there anyway that someone can answer my question without referrin
me to another web site? I am not versed in the use of Excel, which i
why I am here. It seems to me that what I am asking for should be ver
simple for someone who is trained in Excel.

Thanks agai
 
Hi
the good thing about this referred website is that it explains VLOOKUP
with examples and screenshots.
But lets try it here in plain text:
1. Your foriginal spreadsheet is named 'original' and has a layout as
the following:
A B C
1 PIN Sale Date ....
2 123
3 456
....

columns B+C have to be updated by your new sheet

2. Your new sheet is named 'new data' and has the same layout as the
above. It just has column B+C filled.

3. Now use the following formulas in your original sheet:
B2:
=VLOOKUP(A2,'new data'!$A$1:$C$100,2,0)

C2:
=VLOOKUP(A2,'new data'!$A$1:$C$100,3,0)

and then just copy both formulas down. If it could happen that there's
no match for all PIN numbers try the following changed formulas
B2:
=IF(ISNA(VLOOKUP(A2,'new data'!$A$1:$C$100,2,0)),"no
match",VLOOKUP(A2,'new data'!$A$1:$C$100,2,0))

C2:
=IF(ISNA(VLOOKUP(A2,'new data'!$A$1:$C$100,3,0)),"no
match",VLOOKUP(A2,'new data'!$A$1:$C$100,3,0))
 
You will never become well-versed in Excel if you're not willing to use all
the resources that are offered.

Help files in Excel explain VLOOKUP quite well.

Most times, the websites that you are sent to are tried and true and offer the
best info you can find.

The site that Frank pointed you to is one of the best resources for VLOOKUP
help out there.

Being spoon-fed will not improve your knowledge of Excel........nor any other
program for that matter.

You, as someone wanting to learn, should not be so presumptuous as to think
you should dictate the mode of learning.

Frank has given you the basics in his second post. Now go to Debra's site and
have a look at an alternative mode of instruction

Gord Dibben Excel MVP
 
Back
Top