Solved

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

Posted on 2011-03-11
6
316 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 250 total points
Comment Utility
=INDEX(D$7:D$27,MATCH(H6,A$10:A$30,0),1)

Kevin
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
Comment Utility
See attached.

Kevin
exampleone.xls
0
 
LVL 10

Expert Comment

by:Fayaz
Comment Utility
=IF(A10>0,VLOOKUP(A10,H$6:I$8,2,FALSE),"")
exampleone-1-.xls
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 10

Assisted Solution

by:Fayaz
Fayaz earned 250 total points
Comment Utility
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)
Comment Utility
Fayaz: Do you have a normal keyboard with an F5 key on it? Just wondering.
0
 

Author Comment

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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Outlook Free & Paid Tools
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

728 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now