Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Retrieval from spreadsheet
How do I retrive data from my spreadsheet when I type in seperate cells a row
heading(A-column) and a column heading(row8)? I'm trying to retrieve the data to be used in another calculation. When I type the text in a blank cell, I cannot get it to recognize that it matches the headers. I thought that if I could pick out the headers, I could have it send back a value, which I could then use that in the INDEX function. I've tried HLOOKUP and VLOOKUP and I obviously don't understand what's asking me for because I'm not sure how it came up with the answer. I'm using Excel 2000. -- sdaniels |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Retrieval from spreadsheet
Debra Dalgleish has lots of notes on =vlookup() and =index(match()) he
http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) I bet one of those will ease your pain! sdaniels wrote: How do I retrive data from my spreadsheet when I type in seperate cells a row heading(A-column) and a column heading(row8)? I'm trying to retrieve the data to be used in another calculation. When I type the text in a blank cell, I cannot get it to recognize that it matches the headers. I thought that if I could pick out the headers, I could have it send back a value, which I could then use that in the INDEX function. I've tried HLOOKUP and VLOOKUP and I obviously don't understand what's asking me for because I'm not sure how it came up with the answer. I'm using Excel 2000. -- sdaniels -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Retrieval from spreadsheet
As I understand it, you are trying to do a double-lookup.
With Set up your rows and columns, and then in cell G1, enter the value you want to look for in the rows, and in H1, enter the value you want to look for in your columns. Then, use the function below: =INDEX(B2:E5,MATCH(G1,A2:A5),MATCH(H1,B1:E1)) This is just an example; change to suit your specific needs. Hope that helps, Ryan-- -- RyGuy "sdaniels" wrote: How do I retrive data from my spreadsheet when I type in seperate cells a row heading(A-column) and a column heading(row8)? I'm trying to retrieve the data to be used in another calculation. When I type the text in a blank cell, I cannot get it to recognize that it matches the headers. I thought that if I could pick out the headers, I could have it send back a value, which I could then use that in the INDEX function. I've tried HLOOKUP and VLOOKUP and I obviously don't understand what's asking me for because I'm not sure how it came up with the answer. I'm using Excel 2000. -- sdaniels |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Retrieval from spreadsheet
Thanks for your help!
-- sdaniels "sdaniels" wrote: How do I retrive data from my spreadsheet when I type in seperate cells a row heading(A-column) and a column heading(row8)? I'm trying to retrieve the data to be used in another calculation. When I type the text in a blank cell, I cannot get it to recognize that it matches the headers. I thought that if I could pick out the headers, I could have it send back a value, which I could then use that in the INDEX function. I've tried HLOOKUP and VLOOKUP and I obviously don't understand what's asking me for because I'm not sure how it came up with the answer. I'm using Excel 2000. -- sdaniels |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Retrieval from spreadsheet
I tried your suggestion and it gave me funny data returned. This also
happened when I used =vlookup(). Could there be something wrong with my data? -- sdaniels "ryguy7272" wrote: As I understand it, you are trying to do a double-lookup. With Set up your rows and columns, and then in cell G1, enter the value you want to look for in the rows, and in H1, enter the value you want to look for in your columns. Then, use the function below: =INDEX(B2:E5,MATCH(G1,A2:A5),MATCH(H1,B1:E1)) This is just an example; change to suit your specific needs. Hope that helps, Ryan-- -- RyGuy "sdaniels" wrote: How do I retrive data from my spreadsheet when I type in seperate cells a row heading(A-column) and a column heading(row8)? I'm trying to retrieve the data to be used in another calculation. When I type the text in a blank cell, I cannot get it to recognize that it matches the headers. I thought that if I could pick out the headers, I could have it send back a value, which I could then use that in the INDEX function. I've tried HLOOKUP and VLOOKUP and I obviously don't understand what's asking me for because I'm not sure how it came up with the answer. I'm using Excel 2000. -- sdaniels |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data storage/retrieval | Excel Discussion (Misc queries) | |||
Data Retrieval | Excel Discussion (Misc queries) | |||
Userform data retrieval | Excel Programming | |||
Data Retrieval | Excel Programming | |||
retrieval of data from web to excel | Excel Programming |