Thread
:
Formula not working
View Single Post
#
2
Posted to microsoft.public.excel.misc
Domenic
Posts: n/a
Formula not working
Try...
=IF(ISNUMBER($B20),IF(ISEVEN($B20),SUMPRODUCT(VLOO KUP($B20,Control,{14,15
},0)),"CHECK"),IF(ISTEXT($B20),IF(VLOOKUP($B20,Cod es,4,0)="Y","ENTER",IF(
VLOOKUP($B20,Codes,5,FALSE)="Y",0,"CHECK")),"CHECK "))
Hope this helps!
In article ,
Anders Axson <Anders
wrote:
In the following formula, I cannot get the
=IF(ISEVEN($B20),VLOOKUP($B20,Control,14,FALSE)+VL OOKUP($B20,Control,15,FALSE)
,IF(AND(ISTEXT($B20),VLOOKUP($B20,Codes,4,FALSE)=" Y"),"ENTER",IF(AND(ISTEXT($B
20),VLOOKUP($B20,Codes,5,FALSE)="Y"),0,"CHECK")))
My aim is to look at a cell (B20) and do as follows:
If it (the cell) has an even value then lookup that value in another table
and add the two numbers.
If it is text and there is a "Y" in the relveant cell in the lookup, then
display ENTER.
If it is text and there is a "Y" in the other relevant cell in the lookup
then display 0
Otherwise show CHECK.
If I any even number, it works. but if i enter text values, it doesn't.
Reply With Quote