| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does this formula not work? | Excel Discussion (Misc queries) | |||
| How does this formula work? | Excel Discussion (Misc queries) | |||
| FORMULA DOESN'T WORK | Excel Discussion (Misc queries) | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| How do I get this formula to work? | Excel Discussion (Misc queries) | |||
Threaded Mode
