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…:(

[Excel Fox]

Would be best if you can post a sample database with the expected output

[nikhil83]

I have done as you told..please review and get back

[Excel Fox]

K4=INDEX(Salaries!$F$5:$F$10,SUMPRODUCT(MATCH(B4&D4,Salaries!$B$5:$B$10&Salaries!$D$5:$D$10,0))) and drag down

[nikhil83]

Thank you so much for the prompt reply.....