Copy data from sheet 1 to sheet 2

[netrangers]

Hi All,

I need your assistance. I have a spreadsheet with two sheets, Sheet 1
and Sheet 2. Both of the sheets have a FileNumber (Column A) and Name
(Column B). I would like to copy the Name (Column B) from Sheet 2 to
Sheet 1 that matches the FileNumber in sheet 1. Please keep in mind
that some FileNumber (Column A) from sheet 1does not exist in sheet 2.

I would also like to insert a comment in Name (Column A) in sheet 1 if
the FileNumber does not exist in Sheet 2.

Thanks in Advance.

Joseph

 

[Dave Peterson]

=if(isna(vlookup(a1,Sheet2!a:b,2,false)),"Missing",
vlookup(a1,sheet2!a:b,2,false))

This won't insert a comment in the cell in column A, but it will give that
"missing" info in the cell that contains the formula.

Debra Dalgleish has lots of notes on =vlookup() here:
http://www.contextures.com/xlFunctions02.html
and
http://contextures.com/xlFunctions02.html#Trouble