Easier to create a table of numbers in the left column and results in the
right column, then use
=if(A1="","",vlookup(A1,Sheet2!A1:B1000,2,False))
Otherwise
Select Case Range("A1").Value
Case 1
res = "Hello"
Case 2
res = "Goodbye"
Case Else
res = "Not found"
End Select Case
msgbox Res
--
Regards,
Tom Ogilvy
"Liam" wrote in message
oups.com...
Thanks Tom, Sorry I wan't clear enough!
There are a whole bunch of possible values and outcomes, way too many
for a nested IF statement approach.
I was looking for a VB solution something along the lines of Case or If
?