Excel Magic Trick 1488: Vote For Favorite Formula to Lookup Correct Price Based on Effective Date

Click on Link to vote for your favorite formula and try and win a free Excel Array Formula book written by Mike “excelisfun” Girvin.

Related Videos:
Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date
Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date
Excel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date
Excel Magic Trick 1486: VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date
Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date
Excel Magic Trick 1488: Vote For Favorite Formula to Lookup Correct Price Based on Effective Date

[lucaviglio]

Another milestone for someone like me who is having a lot of fun with excel....i really appreciated match combined with index...thanks a lot for all of these amazing videos

[oyekunlesopeju]

VLOOKUP is it ! I love & voted VLOOKUP and Aggregate for backward compatibility. I have both the hard & soft copies of your book.

[NoShadowOfDoubt]

it has to be the first one Lookup - it didn't need anything beyond Excel 2016, but # 3 Formula if I had Office 365. I'm winning everyday by watching your videos... thank you Mike!

[LeilaGharani]

I like the VLOOKUP & Aggregate - also Index & Aggregate :) I already have your great book which I highly recommend to everyone.

[Victor-ollo]

INDEX & MATCH wins.... at least in my opinion. As Leila mentioned already I also can highly recommend your book to everybody.

[vida]

I can't decide which one would be the favourite - all are useful and good

[johnborg]

I personally voted for the Index & Match with the Maxifs, because I liked the index part where you do not have to use CSE and no sorting. I didn't know that you can vote for more than one so I re Voted for the Sumifs & Maxifs since you do not require sorting and joining :) Thanks Mike

[chrism]

I voted, but they are all super helpful

[krn]

Thanks Mike. I voted and already have your book. :)

[MalinaC]

Difficult choice.... :) I've voted for MAXIFS & VLOOKUP :)

[geovane]

You could make a serie of vídeos about statistics using VBA ! I have not seen yet

[SyedMuzammilMahasanShahi]

They are all EXCELlent n you are amazing Mike.

[Sal_A]

INDEX & MATCH, AGGREGATE Array Formula FTW!

[TonyAllenAT]

A sorted helper column (#1484) is the simplest solution and simpler gets my vote when it comes to debugging others' formulas. Sometimes you might have to join more than 2 columns for a unique identifier. Still only requires sorting one simple join column and one easy vlookup. I'm not saying it's the best, but it's my preferred. :) Awesome set of solutions Mike.

[mohamedchakroun]

Yes mike, it is done, good luck for all teammates in the draw :-)

[BillSzysz]

I do not know which one is my favorite. I think, it depends on my mood. I like them all :-))

[MySpreadsheetLab]

Challenging to pick only 1 best solution :)

[عبدالباسطعمران-نه]

Why you didn't vlookup & offset?