Need formula for multiple column match

[aggarwalneha1004]

I have 2 sheets A & B. Sheet A has 3 columns: Store name, Location and no. of products, (50 rows) Sheet B has 3 Columns, Store Name, Location and No. of products (2400 rows), i have values for store name and location in this sheet. Now i want to have value of no. of products in Sheet 2 on condition that combination of store name and location should match in sheet 1 to give me corresponding value. Which formula should i use.

[#2]

Hi,

Please try this formula and find it in the attached file.

=INDEX(SheetA!C:C,MATCH(SheetB!A2&B2,INDEX(SheetA!A:A&SheetA!B:B,),0))

In the attached file, you will find an example similar to what you asking for

I hope this helps you