Battling with VLookup??

VLOOKUP lets you search for specific information in a Worksheet. For example, if you have a list of Product Codes with Prices, you could search for the Price or actual Item for a specific Code.  It also lets you search between different Worksheets.

Its soooo easy when you know how!

  1. Highlight the range you want to analyse (on the OLD sheet) and name the Range. You will then have a range with absolute cell addresses ($ sign) in the formula. Makes copying easy as anything.
  2. Count the columns in the highlighted range before you do the formula.

Vlookup1

  • Go to the NEW sheet, click where you want the answer to be.  Insert the VLookup formula.

Vlookup2

  • Complete as follows:- Vlookup3
  •  Now copy the Formula down.  And Hey Presto!  You have added the data from the OLD sheet, without you having to do a Find, Copy & Paste – through thousands of lines!

(If you already knew how to do this, please enter the Excel Microsoft Champ of South Africa Competition at #ExcelchampSA)

2 thoughts on “Battling with VLookup??

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s