Hi,

I have a query which I don't think can be solved by the use of either h
or vlookup, I'm thinking a combination of both but I guess this doesn't
exist.

I have a list of codes and these need to be looked up against a table
where each code appears in the same column as the value I want to
return. eg

code1
value
value2

code2
value
value2

code3
value
value2

In each instance I would want to go down the list and return the number
that appears in "value" directly under the corresponding code in this
list when it is looked for from my lookup list. I don't think hlookup
would work because I need to find each code below another rather than
across and v lookup wouln't work because I need to find a value below
rather than in an ajoining column. Any ideas?


--
giantwolf
------------------------------------------------------------------------
giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718
View this thread: http://www.excelforum.com/showthread...hreadid=394140