Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » V look ups

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

V look ups

Resolved · Medium Priority · Version 2007

Reply Tue 18 Jan 2011, 16:06Delegate Billi said...

Billi has attended:
Excel Intermediate course

V look ups

How do you do Vlook upx?

For upcoming training course dates see: Pricing & availability

Reply Wed 19 Jan 2011, 12:15Trainer Nafeesa said...

RE: V look ups

Hi Billi

Thank you for your question.

The V-Lookup function is an advanced function & therefore quite detailed to explain in a message without any visual explanation. We do cover this topic on the Excel Advanced course, alternatively for some extra reading see the link below:

http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm

http://vlookup.org/all-about-vlookup/lets-get-started/

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.

Regards,

Nafeesa

Microsoft Office Specialist Trainer

Reply Wed 19 Jan 2011, 12:16Trainer Nafeesa said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Wed 26 Jan 2011: Automatically marked as resolved.

Excel articles

· Create An Improvised Bar Chart In Excel
· Creating Tables Automatically In Excel 2010
· How We Got To The Perfect Spreadsheet: A Brief History
· The Best Way To Use Clip Art Images In Excel
· Using The Drawing Toolbar In Excel

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips