I'm not sure if this is even possible but I have been trying for the last 2 days to make something work.
I have a workbook with 4 sheets all setup the same way and sheet number 4 is a compare sheet. so this is who it works in a nut shell.
Sheet 1 - Walmart
Sheet 2 - Target
Sheet 3 - Kmart
Sheet 4 - Compare
Cells
A1 - has the name of the store (Walmart)
A3 - Name of Product E3 - Cost K3 - Winning Sheet (only on compare page)
I have list a number of items from each store, all the same item, I have there corresponding prices list not on Sheet 4 the goal is to show me the store with the cheapest item and based on that show me what Sheet it came from by displaying what in A1 (name of store) in my K3 column
So far I am getting the lowest price by =MIN(Sheet1:Sheet3!E4) but can't connect that with the sheet it came from???
Any ideas?
I have a workbook with 4 sheets all setup the same way and sheet number 4 is a compare sheet. so this is who it works in a nut shell.
Sheet 1 - Walmart
Sheet 2 - Target
Sheet 3 - Kmart
Sheet 4 - Compare
Cells
A1 - has the name of the store (Walmart)
A3 - Name of Product E3 - Cost K3 - Winning Sheet (only on compare page)
I have list a number of items from each store, all the same item, I have there corresponding prices list not on Sheet 4 the goal is to show me the store with the cheapest item and based on that show me what Sheet it came from by displaying what in A1 (name of store) in my K3 column
So far I am getting the lowest price by =MIN(Sheet1:Sheet3!E4) but can't connect that with the sheet it came from???
Any ideas?