Try this adaptation:
=INDEX(OFFSET(Sheet1!$1:$1,MATCH(A2,Sheet1!A:A,0)-1,),MATCH(L2,OFFSET(Sheet1!$1:$1,MATCH(A2,Sheet1!A :A,0)-1,),0)+1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ravens Fan" wrote:
I used your code to pull the data. It worked when I setup a little test file,
but, when I used it on the actual file I'm trying to match, I get #N/A. The
only difference is they are different columns that I'm trying to match up.
In "sheet2" I'm trying to match data in columns "A" and "L"
and
In "sheet1" I'm trying to match up with columns "A" and "F" to sheet1
columns "A" and "L". Below is the code I used. I'm not totally familiar with
excel, so I'm sure I'm missing something. It's a learn as I go thing.
Anything you can help me with, would greatly be appreciate.
=INDEX(OFFSET(Sheet1!1:1,MATCH(A2,Sheet1!A:A,0)-1,),MATCH(L2,OFFSET(Sheet1!1:1,MATCH(L2,Sheet1!F:F ,0)-1,),0)+1)
--
Baltimore Ravens