typical type of lookup match function

Hi,

This is typical type of lookup which data is needed to extracted from 'Lookup' sheet into 'Required'sheet.

In 'Required' sheet following is to be looked up to match the data.

In 1st C2 & C3
In 2nd C5 & C6
In 3rd C8 & C12 & C13

Above data must be matched with B column and 5th row of 'Lookup' sheet to pull data in 'Required' sheet in D column in respective highlighted cells.

With Best Rgds