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 ...
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