Lookup Value based on 3 criteria

**lexusap** · 03-22-2015, 12:46 AM

Hi,

I am currently building a summary sheet where the data will be obtain from master spreadsheet. The problem I am facing is it requires me to use 3 lookup criteria.

If you look at sheet 1, in order to populate value from cell B4 to D11, there are 3 criterias to be satisfied.
first one is the month, cell A1, second is Sector, A4 to A11 and lastly the date, B3 to D4.

i manage to use Hlookup Match, but i am unable to use OFFSET on top of that formula.

Formula:

Please Login or Register  to view this content.

I have attached the sample spreadsheet and any help would be gladly appreciated.

Thanks
Lex

**FDibbins** · 03-22-2015, 12:54 AM

Try this, copied down and across...
=INDEX(Sheet2!$B$4:$AQ$11,MATCH(Sheet1!$A4,Sheet2!$A$4:$A$11,0),MATCH(Sheet1!$A$1,Sheet2!$B$2:$AQ$2,0)+COLUMN(A1)-1)

**lexusap** · 03-22-2015, 01:00 AM

Hi,

That works like Magic!

Thanks so much. Will need to learn how to write this formula.

Lex

**lexusap** · 03-22-2015, 01:17 AM

Hi,

That works like Magic!

Thanks so much. Will need to learn how to write this formula.

Lex

**FDibbins** · 03-22-2015, 01:30 AM

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)