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


--
JohnK
------------------------------------------------------------------------
JohnK's Profile: http://www.excelforum.com/member.php...o&userid=26498
View this thread: http://www.excelforum.com/showthread...hreadid=398026