Need Help in finding the minimum value across various tabs for different products

Hi,

I have list where the prices of vegetables are updated on a daily basis based for different vendor. Each vendor data is saved on a diff tab.

I want to create a summary tab, where for each vegetable the minimum price for a particular day is captured across all vendors and it also reflects which vendor has the lowest price for each vegetable. Is there any way of doing this.

I have tried minifs , aggregate and other stuff but I am not able to get the desired result.I have attached my worksheet for your reference.

Thanks in advance.

It would really help simplify this if all your sheets had the same format and layout. Some start in row 3 and others start in row 4, while they all appear to start in col E, that is not teh same date across all sheets.

Can you straighten that out, or are you locked into what you show?

Hello rush_2112 and Welcome to Excel Forum.
Perhaps the following will help.
The formula for minimum value is: =MIN('Shop 1- J:Shop 4-P'!E3)
The formula for shop number is: =IF('Shop 1- J'!E3=D4,"Shop 1-J",IF('Shop 2-R'!E3=D4,"Shop 2-R",IF('Shop 3- B'!E3=D4,"Shop 3-B","Shop 4-P")))
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.