Index match different workbooks

[rayted]

Hi guys,

I am battling with 2 worksheets and desperately need some help with an index and match function!

I am looking to have a master moderator file (for a group of moderators) whereby I will input various comments for different moderators each month. In the master moderator file this will be the April tab.

How can I setup index match for the comments relevant to a moderator (see 'test case file') for comments to be input on the 'test case file'.

So for example,

On the test case file. cell B2 should have the data from cell B2 on the master moderator case file? this is for moderator number 171. there will be different moderator numbers for different moderators, hence why i want to use index match - oh and this is just for the april tab! thank you guys