Lookup On Multiple Columns And Return Result Using Match Index

[nikhil83]

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 (Another coloumn in Table 8) figure in corresponding row in Table 8.Following is the formulae I used. But it is returning #VALUE

INDEX(Table8[[#Headers],[CTC]],MATCH('Entry | Project costing'!B4&'Entry | Project costing'!D4,Table8[[#Headers],[Team]]&Table8[[#Headers],[Month]],0))

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. Can we use logical connectives in match function as I have done?

Please help. I have been pondering with this days together…