I am trying to do a vlookup that will look in a different range based on
an input cell.

=vlookup(d1,b1,2,false) where b1 changes to different sheets (i.e. if
b1 = adam, then look in named range adam).

would also like to do it without using named ranges but seem to be
stuck. I tried using indirect(b1) but that didn't work.

thanks in advance

Adam


--
aseanor
------------------------------------------------------------------------
aseanor's Profile: http://www.excelforum.com/member.php...o&userid=29161
View this thread: http://www.excelforum.com/showthread...hreadid=572769