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 :-)