vlookup question, kinda. more of a question about referencing rows

  • Thread starter Thread starter gtjerry80
  • Start date Start date
G

gtjerry80

couple questions:

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

2.) kind of an extension to #1. assuming that i can extract the ro
number from a vlookup returned value, can i use that number (8) to mak
a the range in a separate vlookup formula dynamic? as in i wanted t
have vlookup("Chad",G8:I20,3,FALSE) where the 8 in G8 is referencin
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 vb
coding, but i would really like to stay away from that with thi
particular workbook. thanks in advance for any help.

jerr
 
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)
 
Back
Top