Indirect Function Not working

[dobracik]

Hi all :-)

I was fighting with indirect function, but not successfully :-((

I have a simple workbook split into Monthly sheets per employee ( e.g. January February etc) and Whole Year 2016 ( called Yearly Plan).

What I need is to use indirect value from "Yearly Plan sheet" into monthly sheets. Basically if any code example "Vacation" will be added into Yearly Plan for particular date, it will be visible in sheet for that Month and employee :-)

I have some formulas, but is getting incorrect numbers I should see that results in columns, but is showing in rows, No idea why. For sure, there is some typo in there.

Is there anybody, who would be able to help me with that?

Thank you,
Andy

[JohnTopley]

Try

in I12

=IFERROR(INDEX('Yearly Plan'!$B$11:$O$16,MATCH(January!I$11,'Yearly Plan'!$A$11:$A$16,0),MATCH(January!$B14,'Yearly Plan'!$B$10:$O$10,0)),"")

in I!3

=IFERROR(INDEX('Yearly Plan'!$B$11:$O$16,MATCH(January!I$11,'Yearly Plan'!$A$11:$A$16,0),MATCH(January!$B12,'Yearly Plan'!$B$10:$O$10,0)+1),"")

[Kaper]

Hi Andy,

1) I can't see INDIRECT in your file at all

2) columns and rows are obviously mismatched, so I12:

Please Login or Register  to view this content.

I13 (it is different because of merged cells):

Please Login or Register  to view this content.

copy both right, and while both rows are selected - copy down

[dobracik]

Hi John,

it works :-)) However in Yearly Plan sheet I have per each agent 2 columns, first Column for each is working, the other one not

Not sure, how to modify it a bit.

Thanks

[JohnTopley]

See re-post for formula in I13.

=IFERROR(INDEX('Yearly Plan'!$B$11:$O$16,MATCH(January!I$11,'Yearly Plan'!$A$11:$A$16,0),MATCH(January!$B12,'Yearly Plan'!$B$10:$O$10,0)+1),"")

Then copy pairs of I12 and I13

my error!

[Kaper]

Hi Andy,

You probably missed my post - #3 in this thread

[dobracik]

Worrrkkksss, thanks a lot you both saved my days )

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.