Again, thank you for the help.

One more question: When I type a number in cell A of sheet 1, column A, is
it possible for all of column A, sheet 2 be checked for like number and do
the transfer of data just like below.

"Chip Pearson" wrote:

You only get that dialog when the sheet named in the formula
doesn't exist, so Excel asks you where to find it. What are the
sheet names (on the tabs) of the sheets you're using?


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


"roy.okinawa" wrote in
message
...
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.