Recently my mother suffered a stroke, resulting in my life taking on dramatic changes in order to allow me to care for her. But, I know Dian has had similar
challenges in her own life this year. Therefore, I wanted to help her get some content
into TechTrax. Consequently, this article is shorter than those I've previously written for TechTrax. Hopefully, I'll be able to write longer ones again someday soon.
A few months back my first traditional bound book was published by John
Wiley & Sons, Inc., Microsoft Office Specialist: Excel 2003 Study Guide. You
can learn more about it at my website, http://personal-computer-tutor.com/mos_excelstudyguide.htm.
Although written for those studying for their MOS exam, it's really
suitable for anyone wanting to learn more about Excel. One of the components
that Wiley asked me to include, which I really love, is something called "Real
World Scenarios." This is where I get to tell people how Excel can help them in
real-life situations. Since I'm a teacher, many of the scenarios I
included revolved around how I use Excel in my job. With that in mind, I wanted to share this tip and file with
I'm often asked how to get Excel's VLOOKUP function to pick numbers from
a range and return a corresponding value for any number in that range (e.g.,
grades 90 to 100 are equivalent to a grade of "A"). So, that's what
I demonstrate in this Real World Scenario in my book and I've included the
actual Excel file for you to download. To
understand this best, I'd suggest you read my first VLOOKUP tutorial that I
wrote for a previous issue of TechTrax ( http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=446 ) so you understand how the function works. Then, use this tip (reprinted from
my book, with permission from Wiley publishing) to adapt the formula so it
doesn't require an exact match to find a result.