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 » Vlook ups

	98.1 % recommend us
	More live stats...

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

Training information:

Vlook ups

Resolved · Urgent Priority · Version 2007

Reply Sun 3 Apr 2011, 02:39Delegate Shereen said...

Shereen has attended:
Excel Advanced course

Vlook ups

can i have the answer to the Vlook up sales invoice exercise , my Vlook up doesnt work and i'd like to see why, thanks in advance.

S

For upcoming training course dates see: Pricing & availability

Reply Mon 4 Apr 2011, 11:40Trainer Simon said...

RE: vlook ups

Hi Shereen,

Thank you for your question and welcome to the forum.

Please find attached the answer to the Vlookup exercise.

Thank you for your question.

I hope this answers your question.

Regards

Simon

Attached files...

Sales invoice answers 2007.xlsx

Reply Mon 4 Apr 2011, 11:55Trainer Simon said...

RE: vlook ups

Hi Shereen,

The file is on its way.

Here is the formula for cell B16:

=IF(ISBLANK(A16)," ",VLOOKUP(A16,'Product list'!$A$5:$F$44,3,FALSE))

The formula is saying if B16 is blank then leave a blank in the cell, otherwise if a product code is selected then lookup the relevant information in column 3 of the Product sheet.

I hope this answers your question.

Regards

Simon

Mon 11 Apr 2011: Automatically marked as resolved.

Excel articles

· Streamlining Excel To Save Time
· How To Ensure You Always Make A Complete Data Recovery
· How To Use Conditional Formatting In Excel
· How To Create A Custom List In Excel
· Training Budgets In A Bad Economy

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

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips