Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 16th 05, 06:26 PM
Spock
 
Posts: n/a
Default How do I obtain the address of a cell using the vlookup function?

I'm trying to obtain the address of a cell using the Cell Function and the
Vlookup function. i.e. =Cell("address",vlookup(A2,A320,4,False)) However, I
get an error when I execute the function. Any suggestions?

  #2   Report Post  
Old May 16th 05, 06:32 PM
Mexage
 
Posts: n/a
Default

Why don't you try MATCH instead?

=MATCH(A2,A3:A20,0) will give you the row, relative to the range. For
example, if the value in A2 is in A5, the MATCH function will return 2-5=3.

Hope this helps and if it does please vote for this post.
G.Morales

"Spock" wrote:

I'm trying to obtain the address of a cell using the Cell Function and the
Vlookup function. i.e. =Cell("address",vlookup(A2,A320,4,False)) However, I
get an error when I execute the function. Any suggestions?

  #3   Report Post  
Old May 16th 05, 06:35 PM
Peo Sjoblom
 
Posts: n/a
Default

Not possible using VLOOKUP, try

=CELL("address",INDEX(A320,MATCH(A2,A3:A20,0),4) )


Regards,

Peo Sjoblom


"Spock" wrote:

I'm trying to obtain the address of a cell using the Cell Function and the
Vlookup function. i.e. =Cell("address",vlookup(A2,A320,4,False)) However, I
get an error when I execute the function. Any suggestions?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I find the contents of a cell using the "ADDRESS" function. sweeney Excel Worksheet Functions 2 April 5th 05 03:23 AM
Cell addressing using the content of another cell. De Jandon Excel Worksheet Functions 5 April 1st 05 10:59 PM
Using result from ADDRESS function as a cell reference itself LShutzberg Excel Worksheet Functions 3 December 12th 04 12:18 PM
Passing Cell Address to Offset Bob Excel Worksheet Functions 2 December 1st 04 05:56 PM


All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017