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
Bookmarks