If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
vlookup question, kinda. more of a question about referencing rows
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/ . |
#2
|
|||
|
|||
vlookup question, kinda. more of a question about referencing rows
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/ . . |
Thread Tools | |
Display Modes | |
|
|