x
Solved

# In Excel, how do I lookup the corresponding value of a relatively positioned cell?

Posted on 2011-03-11
Medium Priority
331 Views

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
0
Question by:EEuser5551212
• 3
• 2

LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 1000 total points
ID: 35111286
=INDEX(D\$7:D\$27,MATCH(H6,A\$10:A\$30,0),1)

Kevin
0

LVL 81

Expert Comment

ID: 35111295
See attached.

Kevin
exampleone.xls
0

LVL 10

Expert Comment

ID: 35111381
=IF(A10>0,VLOOKUP(A10,H\$6:I\$8,2,FALSE),"")
exampleone-1-.xls
0

LVL 10

Assisted Solution

Fayaz earned 1000 total points
ID: 35111414
Ealier, I had missed that you need the point "cooresponding value 3 cells up"   See this attachment, both examples included.
exampleone-1-.xls
0

LVL 81

Expert Comment

ID: 35111431
Fayaz: Do you have a normal keyboard with an F5 key on it? Just wondering.
0

Author Comment

ID: 35112295
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.
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.