In column B on sheet1, use

=IF(Sheet1!A1=Sheet2!A1,Sheet2!B1,"")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"roy.okinawa" wrote in
message
...
I need a formula that will allow me to do this:

Worksheet 2 is the master file and contains various
information. Worksheet
1 is the input sheet. If Column A sheet 1 matches Column A
sheet 2, copy
data from Column B sheet 2 and input into Column B sheet 1.

Is this possible? Thanks.