Reference cells in Functions
 

Here is my function

=INDEX('Downloaded Data'!$A$1:$H$495,MATCH(I1,'Downloaded Data'!$I$1:$I$495,0),3

This function is put into the Downloaded Data sheet via a VB procedure. I want "495" to be a variable, which comes from E11 on sheet1. I cannot get it to work.

Please help
Thank you!

Reference cells in Functions
 

Hi
try
=INDEX(INDIRECT("'Downloaded Data'!$A$1:$H$" &
'sheet1'!E11),MATCH(I1,INDIRECT("'Downloaded Data'!$I$1:$I$" &
'sheet1'!E11),0),3)


--
Regards
Frank Kabel
Frankfurt, Germany


Deb Blair wrote:
Here is my function:

=INDEX('Downloaded Data'!$A$1:$H$495,MATCH(I1,'Downloaded
Data'!$I$1:$I$495,0),3)

This function is put into the Downloaded Data sheet via a VB
procedure. I want "495" to be a variable, which comes from E11 on
sheet1. I cannot get it to work.

Please help!
Thank you!

Reference cells in Functions
 

Hi Deb,

=INDEX(INDIRECT("'Downloaded Data'!$A$1:$H$" &
Sheet1!E11),MATCH(I1,INDIRECT("'Downloaded Data'!$I$1:$I$"&Sheet1!E11),0),3)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Deb Blair" wrote in message
...
Here is my function:

=INDEX('Downloaded Data'!$A$1:$H$495,MATCH(I1,'Downloaded
Data'!$I$1:$I$495,0),3)

This function is put into the Downloaded Data sheet via a VB procedure. I
want "495" to be a variable, which comes from E11 on sheet1. I cannot get
it to work.

Please help!
Thank you!

Reference cells in Functions
 

Well Deb,

seeing as I gave exactly the same answer (bar single quotes round Sheet1) as
Frank's phenomenal answer, I am perplexed by your response.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Deb" wrote in message
...
Hi Bob: I'm not sure how to do what you are indicating.