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

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


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

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???
.

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