You didn't say how column B specifies the return range for lookup. If a
3 in column B means the 3rd column from the lookup range (column A) on then:

=VLOOKUP(LookupValue,A:J,VLOOKUP(LookupValue,A:B,2 ,0),0)

JohnK wrote:
Hi

I'm having a little trouble with a VLOOKUP function where I have a
range of values spread over 9 columns with the lookup value appearing
somewhere in the first column. What I need to do is have the function
select the appropriate column based on yet another criteria. So, say I
have a value that gets looked up in the first column as $500, and in
one of the other columns (Column C, say) in the range corresponding to
the looked up value is $350 (which is the $500 less tax say), but each
of the columns represents a different tax rate depending on this other
criteria.

Am I able to use VLOOKUP where Value A ($500) gets looked up in Column
A, but where Value B determines which column to go to across from the
looked up value?

I have a feeling I'm barking up the wrong function here, but I hope
this makes sense. I would be grateful for any suggestions.

JohnK