EEuser5551212
asked on
In Excel, how do I lookup the corresponding value of a relatively positioned cell?
Please see the attached example.xls.
For every value in column A, I need to know the corresponding value 3 cells up and three cells over.
So, I am looking for results that look like cells H6 - I9. (I don't care where the results are, they can be on a seperate worksheet if needed.)
How do I do this?
exampleone.xls
For every value in column A, I need to know the corresponding value 3 cells up and three cells over.
So, I am looking for results that look like cells H6 - I9. (I don't care where the results are, they can be on a seperate worksheet if needed.)
How do I do this?
exampleone.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Fayaz: Do you have a normal keyboard with an F5 key on it? Just wondering.
ASKER
My apologies to you both. I was not accurate or specific enough in my original question. I am awarding you both points, closing without adding to the KB, and will post a better phrased question in another post within 5 minutes.
Kevin
exampleone.xls