One way would be to incorporate Choose
=CHOOSE(VLOOKUP($D$9,Accounts!A1:G500,7,FALSE),Acc ounts!L4,ACCOUNTS!M4,Accounts!N4,etc...)

Obviously you would need to repeat L4 3 times to cover results 1-3 and so on
but this will give you a start.
Choose will permit up to 29 items in its list.

Incidentally, Morrigans assertion that the table must be sorted for VLOOKUP
to work is incorrect.
Provided you use the 4th argument to Vlookup, FALSE or 0, as you have, then
it will work even when the table is not sorted.

--
Regards
Roger Govier
"Phillycheese5"
wrote in message
news:Phillycheese5.1sue3o_1122491338.1206@excelfor um-nospam.com...

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


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile:
http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=390638