Hi Mr Excel,
Would it be possible to do multiple criteria lookup from multiple sheets in which different workbook fr each other by using index/match fomular?
It did work when I tried doing index/match fomular by named the array data in which all sheets is in the same workbook. And it doesn't work if those are in different workbook.
Could you please help?
Example for my case: the same data as your shared file on Jan 20 2011-"Trick 63: 2 Criteria Lookup and Multiple Table Lookup From Different sheet". But the "Mike" sheet will be in different workbook with "Tonsxx" sheet.
Looking forward to hearing from u soon
Would it be possible to do multiple criteria lookup from multiple sheets in which different workbook fr each other by using index/match fomular?
It did work when I tried doing index/match fomular by named the array data in which all sheets is in the same workbook. And it doesn't work if those are in different workbook.
Could you please help?
Example for my case: the same data as your shared file on Jan 20 2011-"Trick 63: 2 Criteria Lookup and Multiple Table Lookup From Different sheet". But the "Mike" sheet will be in different workbook with "Tonsxx" sheet.
Looking forward to hearing from u soon