Hi Ed,

Thank you very much for your help. This looks like a really good solution
which I really like. However, I can not get "MATCH" to function properly. I
tried to read up on it and in the help it says that it should function with
text (which I use) but I only get #N/A value. This is what "MATCH" is suposed
to return when it cannot find a match.

Since I always get #N/A, "ISNUMBER" always returns false and you understand
that it wont give the result I want.

Do you have any idea to why this is so??

By the way, I don't know if it is because of an old version but I have to
exchange all the ":" to ";" to seperate the values in the function. Maybe
thats nothing strange.

//Pontus

"Ed Ferrero" wrote:

Or, closer to what you actually asked for...

=IF(ISNUMBER(MATCH(I6,$B$4:$B$39,0)),B2,I6)

Ed Ferrero
www.edferrero.com