How to get the data from other sheet based on the their corresponding names

Question

Hi,&nbsp;I am having an issue on how to formulate these on my excel file:&nbsp;Ex&nbsp;Sheet 1&nbsp;Fruits&nbsp; &nbsp; &nbsp; Sold&nbsp; &nbsp; Remaining Delivery Total Vendor's Nameapples&nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Markoranges&nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 13&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Angelpeaches&nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mark&nbsp;&nbsp;Sheet 2&nbsp;Vendors Name: Mark&nbsp;Fruits&nbsp; &nbsp; &nbsp; &nbsp;Sold&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Remaining&nbsp; &nbsp; &nbsp; &nbsp; Delivery&nbsp; &nbsp; &nbsp; &nbsp; Total&nbsp; ?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;?&nbsp;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.&nbsp;Thank you.&nbsp;

harun24hr · Accepted Answer

Chaddique&nbsp;You need FILTER() function.=FILTER(Sheet2!A:F,Sheet2!F:F=B1,"Nothing Found")&nbsp;&nbsp;

Forum Discussion

How to get the data from other sheet based on the their corresponding names

2 Replies

Resources