F
Fu2M4n
ok, Lemme explain my project.
NHL workbook, Contains the following :
1-NHL Worksheet
(Contains 6 Groups)
Range B3:B7 = Group 1
Range D3
7 = Group 2
Range F3:F7 = Group 3
Range H3:H7 = Group 4
Range J3:J7 = Group 5
Range L3:L7 = Group 6
Also Contains :
30- Team Worksheets.
(in each of these sheets Cells N4:N9 represent
Group 1 through Group 6)
And to the right of N4:N9 lies the stats that i am trying to Gather up,
Depending on which teams i compare.
Gameday Workbook, Contains the following :
1-Gameday Worksheet.
This will be used to compare 2 teams.
Now here is what i am trying to do.
i want to have a formula in the Gameday workbook the 2 teams i put in
A2 and A3.
=OFFSET(INDIRECT("[NHL.xls]" & A3 &
"!N4:N9"),IF(ISERROR(MATCH($A$2,[NHL.xls]NHL!$B$3:$B$7,0)),
IF it doesnt find A2 in B3:B7 then it should go to D37 and look
there. If it doesn't find it then go to F3:F7 and so on.
Once it finds the corresponding row (in N4:N9) it should grab the data
from the cells using this formula (B2-3.5)*6-3)
For some reason when i add all the IF's it doesn't work. If anyone can
spot my mistake, give me the exact formula i should have to do what i
mentionned above it would be gretly appreciated. Some ppl have told me
i should use VLookup instead? Anyone have any suggestions?
Thanks.
NHL workbook, Contains the following :
1-NHL Worksheet
(Contains 6 Groups)
Range B3:B7 = Group 1
Range D3
7 = Group 2Range F3:F7 = Group 3
Range H3:H7 = Group 4
Range J3:J7 = Group 5
Range L3:L7 = Group 6
Also Contains :
30- Team Worksheets.
(in each of these sheets Cells N4:N9 represent
Group 1 through Group 6)
And to the right of N4:N9 lies the stats that i am trying to Gather up,
Depending on which teams i compare.
Gameday Workbook, Contains the following :
1-Gameday Worksheet.
This will be used to compare 2 teams.
Now here is what i am trying to do.
i want to have a formula in the Gameday workbook the 2 teams i put in
A2 and A3.
=OFFSET(INDIRECT("[NHL.xls]" & A3 &
"!N4:N9"),IF(ISERROR(MATCH($A$2,[NHL.xls]NHL!$B$3:$B$7,0)),
IF it doesnt find A2 in B3:B7 then it should go to D3
7 and lookthere. If it doesn't find it then go to F3:F7 and so on.
Once it finds the corresponding row (in N4:N9) it should grab the data
from the cells using this formula (B2-3.5)*6-3)
For some reason when i add all the IF's it doesn't work. If anyone can
spot my mistake, give me the exact formula i should have to do what i
mentionned above it would be gretly appreciated. Some ppl have told me
i should use VLookup instead? Anyone have any suggestions?
Thanks.