# Entries close Friday! Last chance to register!

#### ModelOff

##### New Member
Registrations for 2014 World Financial Modeling Championships close Friday 5pm NY time.

The World's Ultimate Finance Contest starts Saturday around the world with a 2-hour online challenge. Test your Excel and modeling skills against colleagues and peers - set yourself the goal of reaching Round 2, Gold Class (Top 10%) or even the New York World Finals. There's a challenge for everyone.

ModelOff is for:
ANYONE: Professionals & Students
ANYWHERE: Accessible around the world (90+ countries)
ANY LEVEL: Analysts, Managers, CFOs, etc.

All you need is an internet connection, some decent Excel/VBA skills, and a knowledge of how models are built and can be used. Particularly suitable for people with a finance/banking/accounting/quant/actuarial background.

For all contest details + to register, visit modeloff.com
Entry is \$30USD for Professionals; \$20USD for Students

Email matt@modeloff.com with any questions.

### 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.

1,101,768
Messages
5,482,801
Members
407,363
Latest member
lauren1932

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...