excel

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

Train Strikes - 7th, 12th Nov 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

Excel

resolvedResolved · Medium Priority · Version 2007

Marjorie has attended:
Excel Intermediate course

Excel

Vlookup formula is defeating me .I'm trying to apply it to 2 seperate documents but keep getting NA or value# given back to me me.Can anyone explain in simple steps how to write it?

RE: excel

Hello Marjorie,

Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.

Thank you for your question regarding how a VLOOKUP function is used in a formula.

The main reason you are getting errors when using a VLOOKUP formula is usually because your data has errors in it or the lookup value cannot be found in the lookup table.

Why don't you send me a copy of your spreadsheet with some of your data containing the errors and I will find the problem, fix it for you, and explain exactly why it went wrong.

You can send it to: - rl@stl-training.co.uk

I have attached an Excel file with information on VLOOKUPs which you may find useful.


I await your reply,


Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Attached files...

VLOOKUP Info.xlsx

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.

Thu 20 Dec 2012: Automatically marked as resolved.


 

Excel articles

Please browse our web site to find out more about
excel vba training course london and other training courses.

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

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.