Complex Lookup in Excel for values not in same row/column

[clemenke]

Is there any way to do a lookup in excel that returns a value in the
same relevant place for the lookup value??
For instance can you do a lookup that takes a value and returns a
value that is 2 cells over and 2 down from the value??

I get a report that has data in two columns, each group of data is 2
columns and 6 rows (12 total cells) A social security number is the
2nd cell down in the first row and that needs to be my lookup value.
I need to merge it with other valuse and get it into access so I would
like for the whole set of data to be linear?

Any suggestions?

 

[BrianB]

Use =MATCH() to find the relative row number in the range, and the
=INDEX() to use that row number in the second range (plus 2). Somethin
like :=

=INDEX(E2:E7,MATCH(A1,D27,0)+2