Search in multiple sheets for possible match

[henrik_ros]

Hi fellows

I have a question regarding searching in excel in multiple sheets

I have 3 Sheets

"Production" "Test" "Qualification"

All have the same number of columns (ID, res, text, comment)


What I want to do is:
See if the ID (column A) from the "Production" sheets exists in either "Test" and/or "Qualification".

And if possible highlight that in some way


Regards Henrik

 

[James006]

Hi,

There are many possible solutions to your problem ...

The easy and quick fix is to use the Match() function twice ... for ' Test and for 'Qualification '