Take a range of data and copy to another by matching a unique id

C

CarisaJo

I have one worksheet that holds data that I need in another worksheet. I do
not want to copy and paste, because all of the data may not match up. Is
there a formula that will match the data from the two tables using a unique
identifier existing in both tables and only update those records?
Thanks.
 
S

Shane Devenshire

Hi,

The standard way to do that is with VLOOKUP

=VLOOKUP(A1,Sheet2!A1:D1000,2,FALSE)

This formula would be entered in a blank column of Sheet1. A1 is the unique
identifier on sheet1, Sheet2!A1:D1000 would be a range in sheet2 where column
A contains the unique identifer which you want to match to. 2 indicates that
in this example you want the item in column B on the row with the match to be
returned. False means it is an exact match.
 

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

matching & combining data from seperate worksheets 2
VBA - retrieve data on last create named range from previous inserted named range 0
Create unique list of names from list of duplicates and that arefound within another range 1
matching 1 to 1 and 1 with variations... 3
Get location of match in another worksheet 2
Find match between cells and copy data 7
matching columns to find differences. 0
Align Data 2

Top