How do I reference and update a group of cells, say old account numbers that are to be covered under a new account number? I get 50 or 100 old account numbers on an xls. sheet from UPS that I neeed to update easily to one new account number. Is there a way I can automatically reference or link the old numbers to the one new account number that covers it?
Thanks in advance for any help!
Probably VBA but if you want a formula approach,
in sheet2 Col A has old num, Col B has new numbers
in sheet1, your working sheet, your numbers are in Column D (for example) and in an open column (let's say N) starting in first row of data (let's say 2)
=IFERROR(VLOOKUP(D2, Sheet2!$A$1:$B$100,2, FALSE), D2)
Copy that all the way down.
Then copy and Paste special > Values into Column D.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks