The donut you wish you had not eaten (limbodog) wrote in excel_juice,
The donut you wish you had not eaten
limbodog
excel_juice

vlookup

I consider VLOOKUP to be one of the most handy formulas that Excel has to offer. It's a vertical lookup feature that will scan up and down a list for a specific item, and then return something from that row. At first, this may not seem like overly much, but once you start to mix it with buttons and drop down menus, it gets real powerful real fast. It's a great organization tool.

The syntax for VLOOKUP (I'll try to make a point to put all formulas in caps when referring to them in text) is as follows:

=VLOOKUP([cell],[range],[column],false)

So let's say you've got the list below:
NAMEAGEDUCK
Bob18Mallard
Rob38Pintail
Robert24Wigeon


You select that range (from Bob to Wigeon) and name it "SEARCH". (easy way to name a range is to select it and type in the name you want in the box above the row number indicators. The default in the box would be a cell like "D1")

Now, if you put a formula in cell D5:
=VLOOKUP(C5,SEARCH,3,FALSE)
and type "Robert" into cell C5, you will get "Wigeon" in D5. It looks at C5, finds it in "SEARCH" and returns the 3rd column for that row (counting the name as the first)

A nice feature of this is that using a name for the range allows you to very easily perform these searches across multiple sheets.
Tags: name, range, vlookup
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your IP address will be recorded 

  • 2 comments