Multiple sheet lookup
Hi All,
I am wondering if anyone can help I am looking to create a formula in Excel which looks accross 3 sheets to identify within these sheets if there are duplicate values accross each sheet.
So Ideally it would lolok accross sheets and then in a new overview tab it would return the URLs from those sheets which are duplicate in column a, b, c for example or in one column
Does anyone know anything that could help?
|