Thread: Why does this formula not work?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Why does this formula not work?
Try this revision:
=IF($P30="","Y",IF(AND($W30<"",ISNUMBER(MATCH($W3 0,SAGE3,0))),"Y",""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DaveMoore" wrote:
....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


Reply With QuoteReply With Quote