software

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),V LOOKUP($B20,Codes,4,FALSE)=quot;Yquot;),quot;ENTERquot;,IF(AND(IST EXT($B20),VLOOKUP($B20,Codes,5,FALSE)=quot;Yquot;),0,quot;CHEC Kquot;)))

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 quot;Yquot; in the relveant cell in the lookup, then
display ENTER.
If it is text and there is a quot;Yquot; 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.

Try...

=IF(ISNUMBER($B20),IF(ISEVEN($B20),SUMPRODUCT(VLOO KUP($B20,Control,{14,15
},0)),quot;CHECKquot;),IF(ISTEXT($B20),IF(VLOOKUP($B20,Cod es,4,0)=quot;Yquot;,quot;ENTERquot;,IF(
VLOOKUP($B20,Codes,5,FALSE)=quot;Yquot;,0,quot;CHECKquot;)),quot;CHECK quot;))

Hope this helps!

In article gt;,
Anders Axson lt;Anders gt; wrote:

gt; In the following formula, I cannot get the
gt;
gt; =IF(ISEVEN($B20),VLOOKUP($B20,Control,14,FALSE) VL OOKUP($B20,Control,15,FALSE)
gt; ,IF(AND(ISTEXT($B20),VLOOKUP($B20,Codes,4,FALSE)=quot; Yquot;),quot;ENTERquot;,IF(AND(ISTEXT($B
gt; 20),VLOOKUP($B20,Codes,5,FALSE)=quot;Yquot;),0,quot;CHECKquot;)))
gt;
gt; My aim is to look at a cell (B20) and do as follows:
gt;
gt; If it (the cell) has an even value then lookup that value in another table
gt; and add the two numbers.
gt; If it is text and there is a quot;Yquot; in the relveant cell in the lookup, then
gt; display ENTER.
gt; If it is text and there is a quot;Yquot; in the other relevant cell in the lookup
gt; then display 0
gt; Otherwise show CHECK.
gt;
gt; If I any even number, it works. but if i enter text values, it doesn't.