If Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2070627%22%20slang%3D%22en-US%22%3EIf%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2070627%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20beginner%20at%20IF%20formulae%2C%20so%20it'd%20be%20great%20to%20get%20some%20help%20creating%20a%20formula%20for%20what%20i%20need.%3CBR%20%2F%3EI%20have%20a%20price%20comparison%20sheet%2C%20I%20have%20a%20column%20M%20using%20a%20MIN%20formula%20to%20show%20me%20the%20lowest%20price%2C%20what%20i%20would%20like%20to%20do%20next%20is%20in%20column%20N%2C%20show%20the%20name%20of%20the%20shop%20(which%20is%20in%20the%20top%20row)%20for%20the%20lowest%20price.%26nbsp%3B%20So%20something%20like%20IF%20Column%20M%20is%20the%20same%20as%20Column%20D%2FE%2FG%2FI%2FK%20then%20show%20Row%203%20of%20that%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20could%20anyone%20advise%3F%20all%20input%20greatly%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2070627%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2070749%22%20slang%3D%22en-US%22%3ERe%3A%20If%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2070749%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3BOh%20Amazin%20Thank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

2 Replies

@alitee 

Like this:

=INDEX(D3:K3,MATCH(M4,D4:K4,0))

@Hans Vogelaar Oh Amazin Thank you!