Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default Index Function

I have posted the file DB Practice.xls, at https://mediafire.com, I beleive
that this is a file sharing site unlike the previous site.

I think the questions contained in the file explain the problem I am having
with the index function. I am trying to retreive the intersecting cell value
using the Index Function. I can enter row and column arguments manually and
it works, but when I point to cells on other sheets containing the same
values for the arguments the function returns a ERROR. I wouls appreciate
help. Thanks
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,365
Default Index Function

I think we need a link to the specific file - at which ever site you've got
it at, not just a link to the site's home/main page.
Can you send the file to me as an attachment to an email? If so, send to
(remove spaces from address)
Help From @ jlathamsite. com

I can get it after work today and even post to my webisite and give link to
it for others who may want to jump in and help to grab a copy easily.

"Gulfman100" wrote:

I have posted the file DB Practice.xls, at https://mediafire.com, I beleive
that this is a file sharing site unlike the previous site.

I think the questions contained in the file explain the problem I am having
with the index function. I am trying to retreive the intersecting cell value
using the Index Function. I can enter row and column arguments manually and
it works, but when I point to cells on other sheets containing the same
values for the arguments the function returns a ERROR. I wouls appreciate
help. Thanks

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 15,768
Default Index Function

Jerry,

The OP replied to their own post with a link to the file. Maybe you're not
seeing that reply?

Here's the link if you want to look at the file:

http://www.mediafire.com/?trf3x2zin04

--
Biff
Microsoft Excel MVP


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I think we need a link to the specific file - at which ever site you've got
it at, not just a link to the site's home/main page.
Can you send the file to me as an attachment to an email? If so, send to
(remove spaces from address)
Help From @ jlathamsite. com

I can get it after work today and even post to my webisite and give link
to
it for others who may want to jump in and help to grab a copy easily.

"Gulfman100" wrote:

I have posted the file DB Practice.xls, at https://mediafire.com, I
beleive
that this is a file sharing site unlike the previous site.

I think the questions contained in the file explain the problem I am
having
with the index function. I am trying to retreive the intersecting cell
value
using the Index Function. I can enter row and column arguments manually
and
it works, but when I point to cells on other sheets containing the same
values for the arguments the function returns a ERROR. I wouls appreciate
help. Thanks



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,365
Default Index Function

Ahhh...So. I'll try looking at that this evening - nothing in the inbox here
at the moment, and now it would seem that there need not be. And you were
right - I missed that other post somehow, where ever that was at.

"T. Valko" wrote:

Jerry,

The OP replied to their own post with a link to the file. Maybe you're not
seeing that reply?

Here's the link if you want to look at the file:

http://www.mediafire.com/?trf3x2zin04

--
Biff
Microsoft Excel MVP


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I think we need a link to the specific file - at which ever site you've got
it at, not just a link to the site's home/main page.
Can you send the file to me as an attachment to an email? If so, send to
(remove spaces from address)
Help From @ jlathamsite. com

I can get it after work today and even post to my webisite and give link
to
it for others who may want to jump in and help to grab a copy easily.

"Gulfman100" wrote:

I have posted the file DB Practice.xls, at https://mediafire.com, I
beleive
that this is a file sharing site unlike the previous site.

I think the questions contained in the file explain the problem I am
having
with the index function. I am trying to retreive the intersecting cell
value
using the Index Function. I can enter row and column arguments manually
and
it works, but when I point to cells on other sheets containing the same
values for the arguments the function returns a ERROR. I wouls appreciate
help. Thanks




  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,365
Default Index Function

Well, now it seems I'm not doing something right - the link seems to get
hijacked to some "AtomicRewards.com" site. Arrrrrggggg....

"T. Valko" wrote:

Jerry,

The OP replied to their own post with a link to the file. Maybe you're not
seeing that reply?

Here's the link if you want to look at the file:

http://www.mediafire.com/?trf3x2zin04

--
Biff
Microsoft Excel MVP


"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I think we need a link to the specific file - at which ever site you've got
it at, not just a link to the site's home/main page.
Can you send the file to me as an attachment to an email? If so, send to
(remove spaces from address)
Help From @ jlathamsite. com

I can get it after work today and even post to my webisite and give link
to
it for others who may want to jump in and help to grab a copy easily.

"Gulfman100" wrote:

I have posted the file DB Practice.xls, at https://mediafire.com, I
beleive
that this is a file sharing site unlike the previous site.

I think the questions contained in the file explain the problem I am
having
with the index function. I am trying to retreive the intersecting cell
value
using the Index Function. I can enter row and column arguments manually
and
it works, but when I point to cells on other sheets containing the same
values for the arguments the function returns a ERROR. I wouls appreciate
help. Thanks




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
INDEX function caj Excel Discussion (Misc queries) 1 February 12th 08 09:24 PM
Index Function Mike Excel Worksheet Functions 2 August 27th 07 12:45 AM
Index Function SJT Excel Discussion (Misc queries) 3 November 9th 06 02:54 AM
Index Function/Match Function M Moore Excel Discussion (Misc queries) 3 September 3rd 06 11:49 AM
Emulate Index/Match combo function w/ VBA custom function Spencer Hutton Excel Worksheet Functions 2 May 2nd 05 05:26 PM


All times are GMT +1. The time now is 05:53 AM.

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

About Us

"It's about Microsoft Excel"