error using index and match functions in macro

I'm fairly new to using the index and match functions and this is my first time trying them in a macro. I have a workbook with multiple sheets and in the "Master" sheet I get an error when I run the following code:

Please Login or Register  to view this content.

The error statement says: "unable to get index property of worksheetfunction class."

I'm not sure why because the code runs the first time through the loop and does what it should, but on the second iteration I get the error.

The reason is that if there is no match it post an error
The best way to control it is to add

Please Login or Register  to view this content.

beware that if an error occurs and resumes the cell or the assigned variable will be empty

I appreciate your help and that's actually a very useful tip. As you predicted my code runs fine, but the cell is empty. That narrows down the problem to the formula not finding an exact match.

I'm perplexed though because if I enter the following formula manually in my spreadsheet it works for every cell:
=INDEX(Master!C2,MATCH(G2,Master!D2:D6,0))

The syntax I have in vba is:

Please Login or Register  to view this content.

Note: I changed the order of the values in the Match function because it seems to make more sense this way.

I would break the formula down assigning variables just to be able to "control" their values
for ex. assign cellseeked=sheets(x).cell(i,7) and so forth since I have encountered many forgotten proper initializations before. It is still a mystery to me why do these worksheet functions work or not work...

Thanks for the quick response. I've deleted the non-relevant sheets and attached a sample of the workbook. The code runs when the button on the "Master" sheet is pressed. I have the manual formula as a test in the "Debbie" sheet in column "P" and it is working there.

Thanks for the tip rcm, I'll try breaking the formula down in to variables. That should help me debug the code better too.

The code works beautifully now, thanks so much for your help Norie!
I understand the formula better now to.