returning a cells address from a lookup function - possible?

[jferri]

i would like to return the address of a cell using a vlookup function. does anyone know if this is possilbe? if so, can you show an example of how i may do this?

 

[tactps]

An example would be useful, but try this:

Assuming the data you are looking for is in column F, try this;
="F"&MATCH(A1,F:F)

This will find the first occurance of the text in cell A1 in column F.

Is this what you want?

 

[jferri]

Re: returning a cells address from a lookup function - possi

assume that there is a list of 24 monthly dates in column a (e.g., 1/1/2003, 2/1/2003, etc).

cell b1 contains 1/1/2003, and cell b2 contains 12/1/2004 (each is a data validation list sourced from column a)

and in cell b3 i am trying to count the number of occurances between the dates.

I was trying to use something like the following:

=counta(address(vlookup($G$3,$A$2:$A$25,0,false)):address(vlookup($G$3,$A$2:$A$25,0,false)))

any thoughts?

Thanks

 

[Yogi Anand]

Re: returning a cells address from a lookup function - possi

Hi jferri:

Let us try ... =COUNTIF($A$1:$A$24,">"&$B$1)-COUNTIF($A$1:$A$24,">="&$B$2)

Is this what you are looking for?

 

[jferri]

Re: returning a cells address from a lookup function - possi

great job, thanks!!!!

 

[Brian from Maui]

Re: returning a cells address from a lookup function - possi

Maybe

=SUMPRODUCT(--(A1:A24>B1),--(A1:A24<B2))