Jan 18 2021 04:30 AM
Hi there,
I am a beginner at IF formulae, so it'd be great to get some help creating a formula for what i need.
I have a price comparison sheet, I have a column M using a MIN formula to show me the lowest price, what i would like to do next is in column N, show the name of the shop (which is in the top row) for the lowest price. So something like IF Column M is the same as Column D/E/G/I/K then show Row 3 of that column.
Please could anyone advise? all input greatly appreciated!