I need to search a set of cells:

VLOOKUP(ATable!B2,BTable!$B$2:$B$100,1,FALSE)


but, what if what i need to search changes its location every
time....sometimes its at 2-900.....sometimes its at 5-8......sometimes its at
34-78.....other times its 73-74. Say the name of inside those cells is
SearchRange. so....if you are looking at cells 1-10 in an example u may see
this:

| column B |
-----------------------
1 doesntMatter
2 SearchRange
3 SearchRange
4 SearchRange
5 Search Range
6 doesntMatter
7 doesntMatter
8 doesntMatter
9 doesntMatter
10 doesntMatter

I want to search thru the search range.... in this example it just so
happens to be numbers 2-5. but next time, like i said, it may be at 8-55. I
don't know....so is there a way to do VLOOKUP by reference?

Like:

VLOOKUP(ATable!B2,BTable!$B(SEARCHRANGE):$B(SEARCH RANGE),1,FALSE)


Can someone please help???