http://tinyurl.com/9x3vs

which is rather complicated, easiest would be if you downloaded Morefunc and
use THREED,
same link scroll up a bit



--
Regards,

Peo Sjoblom

Portland, Oregon




"nvermilye" wrote
in message ...

Is there a way to make vlookup look at multiple sheets or ranges?
Norma


--
nvermilye
------------------------------------------------------------------------
nvermilye's Profile:
http://www.excelforum.com/member.php...o&userid=31328
View this thread: http://www.excelforum.com/showthread...hreadid=510337