Assume C1:C10 is the range to vlookup "Rob"

Question1:
=ROW($C$1)+MATCH("Rob", $C$1:$C$10)-1

Question2:
=VLOOKUP("Chad",INDIRECT("G"& (ROW($C$1)+MATCH("Rob",
$C$1:$C$10)-1) & ":I20"), 3, FALSE)


-----Original Message-----
You want to use the function ROW in conjunction with your
vlookup.

Also see http://www.cpearson.com/excel/lookups for other
lookup information.


-----Original Message-----
couple questions:

1.) i performed a vlookup which returned the correct
value (lets say
the value is Robert in cell C8). now, is there a way to
reference the
row that Robert is in, as in having a cell return the
value of 8, or
whatever the row that the vlookup returns?

2.) kind of an extension to #1. assuming that i can
extract the row
number from a vlookup returned value, can i use that
number (8) to make
a the range in a separate vlookup formula dynamic? as
in
i wanted to
have vlookup("Chad",G8:I20,3,FALSE) where the 8 in G8 is
referencing
the 8 which was the row that the first vlookup returned.

phew, i hope that made some sense. i know you can do
this with vba
coding, but i would really like to stay away from that
with this
particular workbook. thanks in advance for any help.

jerry


---
Message posted from http://www.ExcelForum.com/

.

.