Multiple Lookup

[Mohandas]

Dear All,

I have one problem to look up I want to get data based on code and and cd code and closing as it is closing sheet

I have given exam for one row

Can you help

Mohandas

 

[Hui]

In your example you have BS4 = 20
Shouldn't that be 0 and BS5 should be equal to 20?

If that is correct then
C4: =IFERROR(INDEX(DATA!$F$11:$BU$1161,MATCH($A4,DATA!$D$11:$D$1161,0),MATCH(C$2&"Closing",DATA!$F$8:$BU$8&DATA!$F$10:$BU$10,0)),"") Ctrl+Shift+Enter
Copy across and down