Hi Luke

I have tested this as array but doesn't seem to work.
You may want to double check on it again.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"Luke M" wrote:

Your formula is correct, simply enter it as an array, not a regular formula.

Click on cell w/ formula, press F2, the press Ctrl+Shift+Enter. You should
now see the curly brackets around your formula.

Note that your formula doesn't actually check if a value is in field
"eight", it just assumes it is. If D3 contains a text not found anywhere, you
current formula would still return 8.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"nitrofueled" wrote:

I am trying to create a formula within a cell that returns a number (4,5,6,
or 8) based on a series of text entries. The text series are in seperate
columns that have been named (four, five, six and eight) on a seperate sheet.
So far I have written this program with no success:
=IF(D3=four,"4",IF(D3=five,"5",IF(D3=six,"6","8")) ). Any help would be
greatly appreciated...