Help: copy old ss data to new ss, with row mis-alignment

[jay]

Help,

Daily I create a spreadsheet from a database, In column "A" are "Item
Numbers" in random order. I insert a 'new' column in front of column
'A', where I type text comments as I receive verbal updates during the
day.

The next day, I generate a new spreadsheet from the database whose
"Item Numbers" may OR, may not have been on yesterdays spreadsheet.

Currently, my routine is to copy-n-paste yesterdays comments into this
new version which is a pain and time consuming.

QUESTION;

Can someone provide the formula, that if there is a match in yesterdays
"Item Number" to todays speadsheet "Item Number", that it will pull over
yesterdays comments (will all cell formatting) into todays Comments row
matching the same Item Number (remember, the numbers are in random
order within the column) ?

Thanks

 

[Max]

Assuming source data is in sheet named as: 1, with
col A = text comments, col B = item# (#s are assumed unique)
data from row2 down (headers in A1:B1)

In sheet: 2,
Col B = item#, data from row2 down

Put in A2:
=IF(ISNA(MATCH(B2,'1'!B:B,0)),"",INDEX('1'!A:A,MATCH(B2,'1'!B:B,0)))
Copy A2 down

Col A returns the results* from sheet: 1
with unmatched cases returning blanks: ""

*Formulas can return only values, not cell formatting

Freeze the values in col A with an "in-place":
Copy > Paste special > check "Values" > OK

Adapt/extend to suit