Hello and thank you for opening my post. Sorry if I do not properly state my
question.


What I am trying to do is if A3 on Worksheet 1
MATCHES A3 on Worksheet 2
THEN I WANT A6 on Worksheet 1 (A6 is the only blank cell)
to MATCH A6 on Worksheet 2

What is happening is I have a master's product list that states:


ITEM ITEM CODE EST

I have this on both worksheets

However on the firstworksheet the EST is blank and there are not as many
items as worksheet 2

So if the item codes match then I want the EST that is blank to be filled in
with EST that is on worksheet two

Please help :-)

Try this formulas play on a spare copy ..

Assume that data starts in row3 in Sheet1
In Sheet1,
Put in D3:
=IF(C3<"",C3,IF(ISNA(MATCH(B3,Sheet2!B:B,0)),"no
match",INDEX(Sheet2!C:C,MATCH(B3,Sheet2!B:B,0))))
Copy D3 down. Freeze col D with an "in-place" copy, then paste special as
values. Delete col C.

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"conditional format if cell contains word" wrote:
.. What is happening is I have a master's product list that states:
ITEM ITEM CODE EST
I have this on both worksheets
However on the firstworksheet the EST is blank and there are not as many
items as worksheet 2
So if the item codes match then I want the EST that is blank to be filled in
with EST that is on worksheet two

Thank you Max, but I cannot get it to work. I am not sure of what the problem
is. I am very new to going this advanced into Excel and cannot understand
much. I am going to try to play aroudn with it and hopefully I will be able
to communicate better.

"Max" wrote:

Try this formulas play on a spare copy ..

Assume that data starts in row3 in Sheet1
In Sheet1,
Put in D3:
=IF(C3<"",C3,IF(ISNA(MATCH(B3,Sheet2!B:B,0)),"no
match",INDEX(Sheet2!C:C,MATCH(B3,Sheet2!B:B,0))))
Copy D3 down. Freeze col D with an "in-place" copy, then paste special as
values. Delete col C.

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"conditional format if cell contains word" wrote:
.. What is happening is I have a master's product list that states:
ITEM ITEM CODE EST
I have this on both worksheets
However on the firstworksheet the EST is blank and there are not as many
items as worksheet 2
So if the item codes match then I want the EST that is blank to be filled in
with EST that is on worksheet two