The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookups on formulas

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

Vlookups on formulas

Resolved · Low Priority · Version 2003

ReplyFri 29 Jan 2010, 10:57Delegate Christina said...

Vlookups on formulas

Hello,

I have done the following formula =LEFT(B17,3), and then I want to do a Vlookup on the results of the above formula to then pull through the corresponding results. For some reason the results come through as #N/A.

Kind regards,

C Christoforou

For upcoming training course dates see: Pricing & availability

ReplyFri 29 Jan 2010, 16:40Trainer Simon said...

RE: Vlookups on formulas

Hi Christina,

Thank you for your question.

Can you please tell me what the data is in cell B17.

I assume you are trying to take the first three letters from the text like a country code(Aus).

Is the result of the left formula returning correctly? If so are you using the result as your Lookup Value? When you create a Vlookup formula your Lookup Value must be the value that is contained in the first column of your data.

Let me know if this works.

Regards

Simon

ReplyFri 29 Jan 2010, 16:45Delegate Christina said...

RE: Vlookups on formulas

Hi Simon,

Thank you for your quick response. Cell B17 contains "213 London" therefore I am extracting just "213" which comes through correctly. My vlookup table array has 2 columns:

1st being the column with 213 in it
2nd being a corresponding code number eg: 6

Kind regards,

Christina

ReplyFri 29 Jan 2010, 16:58Trainer Simon said...

RE: Vlookups on formulas

Hi Christina,

Thank you for your response.

If your 213 was in cell A1 and the 6 in cell B1 and in cell C1 you type the value you are looking for in the table, then does your formula reflect the one below:

=vlookup(C1,A1:B1,2,FALSE)

Have a good weekend.

Regards

Simon

Excel articles

· Learn The Secrets Of COUNT Functions In Excel
· How To Disguise Error Messages In Excel 2007/2010
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Sorting Birthdates Into Their Respective Months In Excel
· How Excel Can Help You See Into Your Business's Future

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

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips

Can you tell me the difference between MOS and MCAS, and if there are more advanced qualification available?