Match with two conditions & lookups

Hi,


I am try to link to spreadsheets together.


I'm using the first attachment as the input sheet "1, tab analysis" to be pulled into the second file "2 - divisional'


Basically, in the
second file the "position actual tab - I99:Q128) should be pulling from the first file H (below row 21)
second file the "summary actual tab - H6367) should be pulling from the first tab H but the top part (above row 21)
second file the "position YTD tab - I99:Q128) should be pulling from the first file U:AC (below row 21)
second file the "summary YTD tab - G6267) should be pulling from the first tab U:AC but the top part (above row 21)


Im using "'LOOKUP(2,1/((ROW('First page - date'!$A$12:$A$39)>MATCH(LOOKUP("zzzz",F$2:F3,$A$2:$A3)))<MATCH("Total "&LOOKUP("zzzz",F$2:F3,$A$2:$A3),'First page - date'!$A:$A,0))*('First page - date'!$A$12:$A$39=$A4)),'First page - date'!H$12:H$39)" but it doesnt seem to work (not the tab names did not paste well but that funtion)

bobjglover@gmail.com said:

1. Will these 2 files reside in the same server location? If not you will have linking issues.

Click to expand...

Not so - they only need to have the same relative path between them.