Hi everyone,

Attached I have attached a sample of the Index/Match formula that I am using. The formula is working great and does a great job, but I am getting #N/A in some of the cells because there is not a code for that row. Please note that I have used named ranges and the data sheet will be a pivot table and will not have all of the required codes.

I need to know how I can change or add to the formula to get rid of the #N/A in the cells that does not have a code on the data sheet.

The formula that I am using is:
PHP Code:
=INDEX(Data1,MATCH($A3,Code,0),MATCH(B$2,Contract,0)) 
Thanks for any help you can give me.

ET