Hi,

I am having an issue on how to formulate these on my excel file:

Ex

Sheet 1

Fruits      Sold    Remaining Delivery Total Vendor’s Name

apples       2              5              0          7           Mark

oranges     5             6               2          13         Angel

peaches    10            3               1          14         Mark

Sheet 2

Vendors Name: Mark

Fruits       Sold           Remaining        Delivery        Total

  ?              ?                      ?                     ?                 ?

How can I formulate sheet 2 based on changing the Vendor’s name and it automatically gets the data from sheet 1 and fills the corresponding columns on sheet 2? I tried INDEX and MATCH but it only get the first item and when I drag it, it doesn’t get other data based on the name.

Thank you.

​Hi, I am having an issue on how to formulate these on my excel file: Ex Sheet 1 Fruits      Sold    Remaining Delivery Total Vendor’s Nameapples       2              5              0          7           Markoranges     5             6               2          13         Angelpeaches    10            3               1          14         Mark  Sheet 2 Vendors Name: Mark Fruits       Sold           Remaining        Delivery        Total  ?              ?                      ?                     ?                 ? How can I formulate sheet 2 based on changing the Vendor’s name and it automatically gets the data from sheet 1 and fills the corresponding columns on sheet 2? I tried INDEX and MATCH but it only get the first item and when I drag it, it doesn’t get other data based on the name. Thank you.   Read More

​