Hello,

I have just tried this and it worked fine for me. What is the IF statemant
that you are using?
--
Kevin Smith :o)


"Newbeetle" wrote:

Hi,

I have a simple IF statement that looks at A1 to return a number in B1, the
IF statement looks for a word, and return the aloocated number.

This works fine, but I want to use Data Validation in A1 so only the words
I have listed can be selected.

When I use data validation to pick the word, the IF statement then does not
work, so was wondering how I can get around this?

Hope that makes sence.

Newbeetle