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

Copy entire row from another sheet onto first sheet if a unique text matches 1
VLookup sum multiple matches 1
matching & combining data from seperate worksheets 2
Copying Portions of Data 0
Create unique list of names from list of duplicates and that arefound within another range 1
Match/Index/Sum function with date range 2
Pivot Table Mapping 1
Find match between cells and copy data 7

Top