I’ve got an Excel lookup functions question for you, in the quick poll below. And I’ve got some breaking news for you too!
Contextures Monthly Newsletter
First, here’s my news — I’m starting a monthly Excel newsletter, which I’ll send on the second Tuesday every month. That way, it won’t land in your inbox, while you’re scrambling to finish your month-end reports!
I’ve missed staying in touch with you, since I stopped sending my bi-weekly Excel newsletter in November 2021, after 10 years of sending it!
It was always great to get your feedback, and to hear what you were doing in Excel.
So, I hope you’ll join me in this new version of the newsletter. The first issue goes out next week, on Tuesday, June 18th.
Get the News!
You can read a bit more about the newsletter on my Contextures site, and check out some issues of the previous newsletter.
And if you’re ready to try it out, please put your email in the box below, then click Subscribe.
A couple of minutes later, when you get my reply, click the Confirm button. (I added this step to protect you from spam!)
Quick Poll: Excel Lookup Functions
Next, here’s a quick poll about Excel lookup functions. Please let me know which of these functions you’re using most often!
I’ll have the poll results in the newsletter, so you can see what other people are using in their Excel files!
The poll results have been interesting so far!
Loading…
Excel Lookup Functions
Meanwhile, as you wait for next week’s Excel newsletter, here are 3 lookup function videos that you can watch.
And there are lots more lookup function tutorials and videos on my Contextures site, and here on the blog!
Video: Find Product Price with Excel VLOOKUP
In this short video, I show how to make a VLOOKUP formula, to find a product price.
The written steps are on the VLOOKUP Examples page on my Contextures site.
Video: Find Product Price for Quantity with Excel VLOOKUP
In this video, I show the steps for building a VLOOKUP and MATCH formula. Also, you’ll see a problem that can occur if the data is in a named Excel Table.
Video: Get Last Number With Excel LOOKUP Function
And finally, here’s a LOOKUP function video, that I made for the long-ago 30 Excel Functions in 30 Days challenge.
In the video, I show 3 LOOKUP examples:
- Find last number in a column
- Find latest month with negative amount
- Convert student percentages to letter grades
_________________
Which Excel Lookup Functions Do You Use Most Often?

_______________
Original source: https://contexturesblog.com/archives/2024/06/06/excel-lookup-functions-poll/?utm_source=rss&utm_medium=rss&utm_campaign=excel-lookup-functions-poll