Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX function | Excel Discussion (Misc queries) | |||
Index Function | Excel Worksheet Functions | |||
Index Function | Excel Discussion (Misc queries) | |||
Index Function/Match Function | Excel Discussion (Misc queries) | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |