Lookup and Match formula with 2 Criteria

[Neilesh Kumar]

Dear Experts,

Please find here attached Sample Workbook, where i am expecting results in worksheet Report in Cell D10:D11 based on two criteria the first one is Week ending date which is at cell D8 in Report worksheet and the next criteria is for the Region.

Request to you please do help me. Your precious contribution would be appreciated.

Many thanks and regards,

Neilesh

[Special-K]

in Report!D10
=SUMIFS('Raw Data'!D10:L10,'Raw Data'!D$2:L$2,RIGHT(D$5,2)+0,'Raw Data'!D$5:L$5,Working!C$2)

and copy to Report!D11

[Neilesh Kumar]

Thank you so much Special K for your precious phase and valuable support. Dear Expert is it possible to resolve this with If ISNA & Match formula because i was trying by using the If ISNA and Match combination but unfortunately i could not. Please do let me know if its possible.

Many thanks and Regards,

Neilesh

[LeoTaxi]

You have same dates in week 1 and week 2 in sheet Raw Data

this is confusing

Kind regards
Leo

[Neilesh Kumar]

Dear Expert LeoTaxi, I do apologies for the inconvenience, I have replaced the file with the correct dates.