Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2011-03-11
6
Medium Priority
?
331 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:EEuser5551212
  • 3
  • 2
6 Comments
 
LVL 81

Accepted Solution

by:
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

by:zorvek (Kevin Jones)
ID: 35111295
See attached.

Kevin
exampleone.xls
0
 
LVL 10

Expert Comment

by:Fayaz
ID: 35111381
=IF(A10>0,VLOOKUP(A10,H$6:I$8,2,FALSE),"")
exampleone-1-.xls
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 10

Assisted Solution

by:Fayaz
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

by:zorvek (Kevin Jones)
ID: 35111431
Fayaz: Do you have a normal keyboard with an F5 key on it? Just wondering.
0
 

Author Comment

by:EEuser5551212
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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.

Join & Write a Comment

This article presents several of my favorite code snippets.
You can use the network upload option and the Office 365 Import service to bulk-import PST files to user mailboxes. Network upload means that you upload the PST files a temporary storage area in the Microsoft cloud.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question