Solved How do I compare data over 3 worksheets

May 20, 2019 at 12:03:58
Specs: Windows 7
I have a excel workbook of which have the tabs called "WATFORD" "TABLEAU" "PREV REC" . What im trying to do is to look at the data in the tab called "TABLEAU" and compare it with data whats in "WATFORD" and "PREV REC" if the data is an exact match in columns A/B/C/D of either WATFORD or PREV REC sheets I need it to say "OK" in column "E" of the TABLEAU tab and also the tab where the matching data is.

If there is NO match in any tab I need it to show N/A

Any Ideas?


See More: How do I compare data over 3 worksheets

Reply ↓  Report •

#1
May 20, 2019 at 17:25:22
✔ Best Answer
Without knowing the layout of your three sheets the easiest way would probably be some type of lookup.

You could enclose them in a nested IF()

First lookup to WATFORD, if they match them lookup to PREV REC and if you get a match then OK, else N/A.

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question