Quote:
Originally Posted by Dotty
I require it to return an error message in workbook (2 ).
|
You can try
Copy both workbooks in the same folder, eg C:\test
Open Workbook2 and add two extra columns that you can hide
Set two VLOOKUP formula (see attach)
In the B and C column set two conditions for Conditional Formatting, if the condition does not match paint it red font