A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old December 11th, 2003, 10:36 PM
drabbacs
external usenet poster
 
Posts: n/a
Default 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  
Old December 11th, 2003, 10:53 PM
Li Cao
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:07 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.