Forum Discussion
Need formula for multiple column match
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.
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
