• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple Lookup

M

Mohandas

Member
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
 

Attachments

  • Copy of AP CDCLS Sept 2016.xlsx
    380.1 KB · Views: 7
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
 
You must log in or register to reply here.
Back
Top