excel courses in london - v lookup

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Train Strikes - 7th & 12th November 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - V Lookup

excel courses in london - V Lookup

resolvedResolved · Low Priority · Version Standard

Julian has attended:
Excel Intermediate course

V Lookup

What's the easiest way to create a V Lookup?

RE: V Lookup

Hi Julian,

The vlook up function will based on the lookup value supplied, start searching from the first column in the lookup array for the row that the lookup value appears in the table array. It will then use the lookup column argue supplied to return the value of the cell in the column specified. The wizard gives you tips and guidance that is probably a good place to start. Get back to me if you have a problem

Tracy


 

Excel articles

Excel tip:

Viewing two Excel 2010 Workbooks at the same time

Did you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth!

1) Open both Excel workbooks
2) Select Window then select Compare Side by Side with (Spreadsheet 2)
3) When you have finished, select Window again and click Close Side by Side

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.