vlookup reverse// please help

cecman · 02-12-2005, 11:06 PM

I would like to reference column 1 from the value looked up in column 8.
How???

**duane** · 02-12-2005, 11:18 PM

you can do it with inex and match or offset and match

for example

offset(a1, match(your lookup value,h1:h1000,0)-1,0)

or

offset(h1, match(your lookup value,h1:h1000,0)-1,-7)

R.VENKATARAMAN · 02-13-2005, 12:06 AM

try <match> and <index> functions. excel help on these functions will be of
help

cecman <[email protected]> wrote in message
news:[email protected]...
> I would like to reference column 1 from the value looked up in column 8.
> How???

Biff · 02-13-2005, 12:06 AM

How about some details???

Index/Match or Offset

Biff

>-----Original Message-----
>I would like to reference column 1 from the value looked
up in column 8.
>How???
>.
>

Dave Peterson · 02-13-2005, 10:06 AM

And Debra Dalgleish has some nice instructions (for both =vlookup() and
=index(match()) at:

http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

cecman wrote:
>
> I would like to reference column 1 from the value looked up in column 8.
> How???

--

Dave Peterson