Data Replacement Question - Basic

[JrzWrld]

Any help on this would be appreciated - I have a suspicion this is a pretty basic question (at least I hope it is).

I have a formatted spreadsheet with unique identifiers for each row (unique identifier is in its own column). However one column of data is incorrect and needs to be replaced. And I would like to do that without reformatting the entire spreadsheet.

How do I take the NEW column of data (which is correctly aligned with the same unique identifiers that are also in the original spreadsheet - the unique identifiers are also in a separate column in the new, corrected file as well) and align the new data with the correct unique identifiers in the pre-existing spreadsheet? BTW, there are more rows of data with unique identifiers in the new columns of data than in the original, and the unique identifiers in the first spread sheet are sorted subjectively and therefore cannot be "unsorted" and then resorted with any sort of accuracy.

 

[Andrew Poulsom]

Welcome to the Board.

Try a formula like:

=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

where A1 contains the unique ID and columns A:B on Sheet2 contain the ID and corrected value.

 

[JrzWrld]

Thanks! I will give that a shot as soon as I get the new data.