Important The values in array must be placed in ascending order: ...,-2, -1,
0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give the correct
value. Uppercase and lowercase text are equivalent
--
paul
remove nospam for email addy!



"tracy" wrote:

I have a Lookup command and it's working for everything but the last entry in
the source list
=LOOKUP(A8,WKFLDS!A14:A39,WKFLDS!B14:B39)
Entries in rows A14:A36 are found successfully, but A37 returns a blank even
though there is data in B37
Rows 38 and 39 are currently blank