Dueling Excel - "Price Beneath Lookup Value": Podcast #1424

Play Now -->

DATE : Mon, 12 Sep 2011 18:54:51 +0000
Entered in Database : 2011-09-12 18:54:51
length : 19311376
Link to the Show / Show Notes

Today’s Dueling Excel features a question from a YouTube viewer, who asks: “”How can I be sure that a price value entered into my spreadsheet is actually less than the upper limit in my lookup table. In Episode #1424, Bill “MrExcel” Jelen and Mike “ExcelisFun” Girvin compare two different methods: one using Data Validation and one using Conditional Formatting.

Dueling Excel Podcast #82…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions