Need cell location instead of value from any array searching formula - vlookup, match, etc

I'm using excel 2010. What would be ideal for me is if there is a way for VLOOKUP to return the location of the cell instead of its value from a sorted array. I need a value from the next row down. I don't think VLOOKUP will do this and cannot find any other array searching function that will. Any ideas?

Thanks for the idea, but it's not quite what I'm looking for. I have an array such as

A. B.
10 small
20 medium
50 large

When my searching cell contains 30, i want to finally get an answer of "large". Assuming my array is rows 1 to 3 and columns 1 and 2, then VLOOKUP(search-cell,a1:b3,2) returns "medium". So I thought if I could find a way of getting the cell address of the cell containing "medium" (which is b2) then I could manipulate it into giving me the contents of the next cell down (b3 which contains "large").

BTW, I'm new here. How did you create that "Formula" box?