Why does this formula not work?
....and how should it be written?
=IF($P30="","Y",IF(AND($W30<"",VLOOKUP($W30,SAGE3 ,1,FALSE)=
$W30),"Y",""))
If the value of cell W30 is also present in the table SAGE3 there is
no problem. The error occurs if it is not.
I have tried changing FALSE to TRUE but this does not work either.
The table SAGEŁ has been sorted by the first field.
Can anyone help?
Dave Moore
|