• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

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
0
EEuser5551212
Asked:
EEuser5551212
  • 3
  • 2
2 Solutions
 
zorvek (Kevin Jones)ConsultantCommented:
=INDEX(D$7:D$27,MATCH(H6,A$10:A$30,0),1)

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
See attached.

Kevin
exampleone.xls
0
 
FayazCommented:
=IF(A10>0,VLOOKUP(A10,H$6:I$8,2,FALSE),"")
exampleone-1-.xls
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
FayazCommented:
Ealier, I had missed that you need the point "cooresponding value 3 cells up"   See this attachment, both examples included.
exampleone-1-.xls
0
 
zorvek (Kevin Jones)ConsultantCommented:
Fayaz: Do you have a normal keyboard with an F5 key on it? Just wondering.
0
 
EEuser5551212Author Commented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now