VLOOKUP WEEK Drawing for Tuesday 27-Mar-12

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Mar 28, 2012.
Using VLookup, Bill selects two winners!
maxresdefault.jpg


Transcript of the video:
Hey, welcome back.
It’s Bill Jelen on Tuesday of the VLOOKUP week was hilarious.
As people post their Ode to VLOOKUP and we got excellent responses.
Some of my favorites here, Michael Pennington rocked out a haiku, Ray Double U.
He sent in a poem that actually has words rhyming Jelen.
Yoohoo!
Keep J wrote a very long poem.
Elaine remembers her college professor walking in, pulling up a job board, and typing in VLOOKUP, and Pivot Table, and showing how many jobs were dependent on knowing that bends.
And watch out, VLOOKUP is the gateway formula.
Pretty soon you’ll be addicted to Power Pivot.
EFS Express it is a formula.
All of these were great.
Now, we have two prizes from Tuesday, the formulas and functions book, Paul McHenry’s donated by Q.
So, we have 20 items here I’m going to name this range.
I’m going to call it Entrants.
So, now we have a named range right here.
I’ll select this cell and this cell =INDEX(Entrants,RANDBETWEEN(1,20)).
Do CTRL + ENTER.
There we go.
Hey, alright.
So, Jack wins the book and oops, Simon wins the LOOKUP Week t-shirt.
Check back tomorrow.
 

Forum statistics

Threads
1,214,601
Messages
6,120,460
Members
448,965
Latest member
grijken

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top