Lookup based on multiple criteria

[sasindiv]

Hi,

I am trying to do a simple lookup based on multiple criteria. I went to use SUMIFS instead of Match and Index as i need not use arrays.

I have attached the excel sheet, i am not sure what is the issue with the formula, maybe i am missing something..


This is the formula i use. I need to populate the cell based for a company for a particular date.

Please Login or Register  to view this content.

Can you please help me in resolving this...

[Pete_UK]

You can use this formula:

=VLOOKUP($B$1,Sheet2!$A:$AF,MATCH(Sheet1!C$3,Sheet2!$1:$1,0),0)

Hope this helps.

Pete

[sasindiv]

Thanks Pete You nailed it