In my workbook I have 2 sheets named Project costing and salaries .Each sheet has 1 table . i need to compare Resource Name and Month in Table in ‘Project costing’ sheet with that in another table -Table 8 in ‘Salaries’ sheet. If ‘Resource Name + Month’ combination is matching in both tables, then formulae has to return CTC figure in corresponding row in Table 8.Following is the formulae I used. But it is returning #VALUE<o
></o>
INDEX(Table8[[#Headers],[CTC]],MATCH('Entry | Project costing'!B4&'Entry | Project costing'!D4,Table8[[#Headers],[Team]]&Table8[[#Headers],[Month]],0))<o></o>
B4 has resource name and D4 has Month entry in the table in project costing sheet. ’Team’ coloumn has resourse name and ‘Month’ coloumn has month entry in Table 8 in ‘Salaries’ sheet.<o></o>
Please help. I have been pondering with this days together…
></o>INDEX(Table8[[#Headers],[CTC]],MATCH('Entry | Project costing'!B4&'Entry | Project costing'!D4,Table8[[#Headers],[Team]]&Table8[[#Headers],[Month]],0))<o
></o>B4 has resource name and D4 has Month entry in the table in project costing sheet. ’Team’ coloumn has resourse name and ‘Month’ coloumn has month entry in Table 8 in ‘Salaries’ sheet.<o
></o>Please help. I have been pondering with this days together…
