OK. It is working now, however before it copies itself, a Update Values
screen pops up asking to choose a excel file. Which would be the same file I
am working from. Should that happen?

Thanks

"Chip Pearson" wrote:

Since both Sheet 1/2, cell A match, the number from sheet 2,
cell B should
have copied over to sheet 1, cell B. Correct?

Correct. The formula works for me. Are you sure you are using
the correct sheet names?


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




"roy.okinawa" wrote in
message
...
I getting a #REF in cell B on sheet 1. ???

Since both Sheet 1/2, cell A match, the number from sheet 2,
cell B should
have copied over to sheet 1, cell B. Correct?

"Chip Pearson" wrote:

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.