Returning the desired value if multiple values exist????

  • Thread starter Thread starter njuneardave
  • Start date Start date
N

njuneardave

Hi......big question here:

please look at this chart:


SHEET1 SHEET2
Shape | Color Shape | Color
------------------------
-------------------------
box blue box
blue
box red box
red
box pink box
pink
circle blue cirlcle
blue
circle green circle
green
circle pink circle
aquamarine
circle red circle
red


SHEET3
Shape | Color
---------------------------





circle pink



so, I want to verify that the contents in Sheet1 are the same as Sheet
2....if not, I want to record the changes in sheet3 (only show the
changes). How do I search Sheet2 for pink circle? What function would
I use?
 
sorry about the previous post.... .here is a cleaned up version of
the table.

A big concern of mine is: What if a row is added on the next
run....like another box
is added, will this mess things up?

SHEET1 SHEET2
Shape | Color Shape | Color
------------------------ -------------------------
box blue box blue
box red box red
box pink box pink
circle blue cirlcle blue
circle green circle green
circle pink circle aquamarine
circle red circle red


SHEET3
Shape | Color
---------------------------





circle pink
 
Back
Top