-
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.
starters
- Thread starter The Tamer
- 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.
-sam
Board Regular
- Joined
- Jul 16, 2002
- Messages
- 117
I'm deeply confused. I thought this thread was going to be about baseball, and the lack of ability of a certain New York team's starting pitching this postseason. 
Of course right about now I think just about everything is about baseball. Bring on the Cards! 
-sam
Of course right about now I think just about everything is about baseball. Bring on the Cards! -sam
L
Legacy 32701
Guest
Baseball? Is that the game that's like Rounders and is even more boring than cricket?
Zack Barresse
MrExcel MVP
- Joined
- Dec 9, 2003
- Messages
- 10,881
- Office Version
- 365
- 2010
- Platform
- Windows
- Mobile
- Web
I would expect that from you ..Sonny Bop said:
GO SOX!
NateO
Legend
- Joined
- Feb 17, 2002
- Messages
- 9,700
Touché.Sonny Bop said:
My original post to this thread was in jest, I happened to read your posted procedure and the 'essay' (which reads like a rant at times in my opinion) around the same time.
I do not necessarily agree with the author of aforementioned link. Generally speaking, brief, valid and efficient syntax strikes me as fair game (I'm not advocating the use of spaghetti code).
