Actually char(224) is equivalent to [Alt+0224] which is "Ã*" and this will not
work as the lookup value needs to always sort to the bottom of the list.

Without a leading zero, [Alt+224] is ascii, see: http://www.asciitable.com/.
In windows unicode it is 03B1 in hex or chrw(945) in vba and any other such
extended character should also work.

"Dave Peterson" wrote:

Just because I could never remember how I made that funny character:

=LOOKUP(char(224),A1:E1)



Lori wrote:

Or a bit shorter

=LOOKUP("α",A1:E1)

where "α" is the alpha character [Alt+224] or inserted with insertsymbol.

"T. Valko" wrote:

Try one of these:

=INDEX(A1:E1,MATCH(REPT("Z",255),A1:E1))

=IF(COUNTIF(A1:E1,"*"),INDEX(A1:E1,MATCH(REPT("Z", 255),A1:E1)),"")


--
Biff
Microsoft Excel MVP


"JulesMacD" wrote in message
...
I have 5 columns containing different supervisor levels. Some columns are
blank. I would like to write a formula to evaluate the 5 columns and
return
the name in the farthest right column. Thank you!




--

Dave Peterson