Hi,
I have Vlookup formulas in Cell A1 & B1 which is showing the result as #N/A due to data not available in the range I selected.
Since both A1 & B1 is showing result as #/NA, i need to know whether both these cells are having same results are not. To know the result i will use the formula
as A1=B1, but its now showing as true or false instead its showing #N/A only. Please help how to get the True or false result for these cases.
Bookmarks