excel courses in london - Vlookups

Resolved · Low Priority · Version Standard

Tue 21 Aug 2007, 09:52 Delegate Lisa said...

Lisa has attended:
Excel Intermediate course

Vlookups

My VLOOKUPS often give me half of the data that I am looking up. For example, with a recent postcode checker, although the postcodes were on the next worksheet, the data did not filter through to my worksheet. What am I doing wrong?

Thu 30 Aug 2007, 10:14 Trainer Katie said...

RE: Vlookups

Hi Lisa,

Thank you for you question.

The key for making a VLOOKUP function, you must count the columns correctly.

I assume your VLOOKUP function is placed on a different sheet from the postcodes. the VLOOKUP function should read:
=VLOOKUP(search cell, Sheet_name!datatable cell range, column number of Postcode)

Let me know if this is enough.

Katie

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

excel courses in london - Vlookups

Vlookups

RE: Vlookups

Excel articles

Excel tip:

Adding date and time

Training Programs
Professional & Management Development