Copying an adjacent cell text from another sheet, if cell exist

Closed
Jeff68 - Oct 11, 2016 at 05:42 AM
Hello,

I have 2 excel sheets with lists (+5000 rows) of unique parameter names (text) on each row starting from A2.

Sheet 1 has only the parameters I need but no comment on B2.
Sheet 2 has a bigger list of parameters with comment cell on B2 for each parameter.
Not all parameters from Sheet 1 exist on Sheet 2, i.e. the rows don't match. For the parameters that exist on both sheets not all of them have a comment on Sheet 2.

I want to copy the comment cell text from Sheet2 B2 to Sheet1 B2 if the parameter A2 is found on both sheets.

How can I do that? Thanks in advance!