S
sdaniels
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.
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.