Find lowest value in corresponding cells on multiple worksheets. Return value & location.

**WORKINGBEE** · 02-19-2013, 04:17 PM

Hello,
I have a workbook containing prices in 4 worksheets using the same template. I need to tell excel to list the name of the sheet with the lowest value for each cell in one column and the actual lowest value in another column of my 5th worksheet. I have attempted formulas using the MIN and IF formulas, but I get various errors. Can someone tell me how to accomplish this? I appreciate any replies. Thank you.

**p24leclerc** · 02-19-2013, 05:06 PM

here is a formula to find the lowest price out of your 4 sheets:

Please Login or Register  to view this content.

here is a formula to find the sheet name with the lowest price:

Please Login or Register  to view this content.

**WORKINGBEE** · 02-19-2013, 06:48 PM

Thank you for your response.

Find lowest value in corresponding cells on multiple worksheets. Return value & location.

LinkBack

Thread Tools

Rate This Thread

Display

Find lowest value in corresponding cells on multiple worksheets. Return value & location.

Re: Find lowest value in corresponding cells on multiple worksheets. Return value & locati

Re: Find lowest value in corresponding cells on multiple worksheets. Return value & locati

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions