need help regarding vlookup

[abid hussain]

Dear Sir/ Madam,

Hope you are doing well, Sir, I need your help in this worksheet regarding (Vlookup)

I want lookup data from two sheets at “Arrear sheet” lookup from Cell: C2 and B7 and getting data from “DATA” sheet.

For e.g.. VLOOKUP Cell: C2 and B7 in Arrear Sheet and get data from “DATA” sheet.

 

[shrivallabha]

In cell D7, you can try following formula:
=IFERROR(INDEX(DATA!$J$3:$AM$903,MATCH(ARREAR!$C$2&ARREAR!$B7,DATA!$C$3:$C$903&DATA!$B$3:$B$903,0),MATCH(ARREAR!D$6,DATA!$J$2:$AM$2,0)),"")
which you can copy down and across.
Note: You may have to use Array Entry (CTRL+SHIFT+ENTER) if you are using Excel version other than office 365.

 

[abid hussain]

Thank you so much Sir.