excel courses in london - vlookups

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses in london - Vlookups

excel courses in london - Vlookups

resolvedResolved · Low Priority · Version Standard

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?

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


 

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


Server loaded in 0.09 secs.