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