-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Happy New Year!
- Thread starter Smitty
- Start date
Excel Facts
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
I hope you didn't kiss all of them 
NateO
Legend
- Joined
- Feb 17, 2002
- Messages
- 9,700
I hope you didn't kiss all of them
The dude on the 2nd to right tried to kiss me, but his advances were successfully quashed!
Last edited:
DonkeyOte
MrExcel MVP
- Joined
- Sep 6, 2002
- Messages
- 9,124
I just realized that's Mike Redmond on the far left, the Minnesota Twins' (back-up) catcher. The kisser is on the far right.
It's nice to see that even the stars of MLB resort to wearing their blackberry on their belts...
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
Cheeky bugger!
Now what was I doing? Oh yes:
"Dear Tom, on the subject of Mr Nathan Oliver...."
Now what was I doing? Oh yes:
"Dear Tom, on the subject of Mr Nathan Oliver...."
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
I just realized that's Mike Redmond on the far left, the Minnesota Twins' (back-up) catcher. The kisser is on the far right.
Looks like he's not too good since he's wearing a waiter's outfit.
But a hearty heah-ho on kissing the "twins"...
NateO
Legend
- Joined
- Feb 17, 2002
- Messages
- 9,700
My goodness, Richard's launching haymakers in 2009?
I see your tactical strike and raise you, one. I can now picture my next email...
"Dearest Vicki, it's not often I make mistake... It's even rarer that I admit it, but on the subject of Mr. Richard Schollar..."
Mike Redmond is actually very good for a backup, he's not Joe Mauer, but very solid for a 2nd tier MLB player.
I see your tactical strike and raise you, one. I can now picture my next email...
"Dearest Vicki, it's not often I make mistake... It's even rarer that I admit it, but on the subject of Mr. Richard Schollar..."
Mike Redmond is actually very good for a backup, he's not Joe Mauer, but very solid for a 2nd tier MLB player.
