Update new list from old list

  • Thread starter Thread starter BdgBill
  • Start date Start date
B

BdgBill

I have a list of stores....

Store number is in column A, lat/long is in coulumn b and c.

Every month i get a new list which does not include lat/long data. New
stores appear on the list, closed stores are missing from it. I want
the new list to look up the store number on the old list and copy the
lat/long data from coulumns b and c of that row to the blank cells in b
and c on the new list.

I think the function is VLOOKUP but I cant get it to work.

I currently have to beg someone in my office to do this for me using
access. He says its impossible to do with excel. Would love to prove
him wrong :cool:
 
Hi
sure this is possible :-)
For your colleague:
Asumptions:
- sheet 1 is the new list with only column A
- sheet 2 is the existing list from which you want to transfer column
B+C

Enter the following in B1 on sheet1
=IF(ISNA(VLOOKUP($A$1,'sheet2'!$A$1:$C$1000,2,0)),"new
store",VLOOKUP($A$1,'sheet2'!$A$1:$C$1000,2,0))
and in C1 enter
=IF(ISNA(VLOOKUP($A$1,'sheet2'!$A$1:$C$1000,3,0)),"new
store",VLOOKUP($A$1,'sheet2'!$A$1:$C$1000,3,0))
copy both formulas down
 
This works!

You guys are ore helpful than the 30lbs of excel books i have in fron
of me!

Thanks again
 
Back
Top