It will still be within one cell but you have a VLOOKUP() within another
VLOOKUP().

Assuming you are searching for account name then return a number. Then
the next VLOOKUP() search for this number from another table and return
another value(a label in your case "Mid Cap" etc)

ie.
VLOOKUP(VLOOKUP(account name, table1, return number), table2, return
label)


Hope it helps.



Phillycheese5 Wrote:
I was hoping to get it into 1 cell where it checks for multiple ranges
and series of numbers. Thanks.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390638