HELP #REF Error on Index/Match

[Nudie072]

Hi,

I have a index match forumla, that is returning a #ref. It works fine in first column, but returns the #ref in the next columns.

I need to match SAP CODE and COLUMN header on tab forcastcast sheet with table in tab ALL. I recived from 5 different customers forecasts and the copy and past them to table [Forcast_table] in the ALL TAB. on tab Forecast sheet i index match in H13 =INDEX(Forcast_Table[[APR]:[MAR]],MATCH($G13,Forcast_Table[CUSTOMER NAME],0),MATCH($D$13,Forcast_Table[SAP CODE],0),MATCH(H$12,Forcast_Table[[#Headers],[APR]:[MAR]],0))
(This is the column that works)

what am i missing? why the #ref in colmun I-P?

i need to paste this formula in each cell fo each Sap Codes listed in the Forecast Sheet Tab?

Is there a better way to do this?

Here is a sample file

 

[NARAYANK991]

Hi ,

See the attached file ; I have put in the formula for the first 3 categories.

Narayan

 

[Nudie072]

WOW that formual has s little bit of work in it, that would have taken me a month of sundays to work out. AWESOME, Thanks so much for your help,ths is going to make life so much easier.