Clueless as to how to write VLOOKUP formula

  • Thread starter Thread starter moodwalker
  • Start date Start date
M

moodwalker

I have just started a summer class that is basically an Excel class.
The teacher doesn't really show us how to do anything and I am a novice
excel user at best. I have a lab that requires us to use VLOOKUP and I
am totally lost. Anyone have any tips on a training website or where I
could find this information. :mad:
 
moodwalker said:
I have just started a summer class that is basically an Excel class.
The teacher doesn't really show us how to do anything and I am a novice
excel user at best. I have a lab that requires us to use VLOOKUP and I
am totally lost. Anyone have any tips on a training website or where I
could find this information. :mad:
Click to expand...

Moodwalker,
http://www.contextures.com/xlFunctions02.html
and
search - Google
Dave
 
Have you taken a look at Excel's Help file? It's full of lots of useful and
concise examples.
 
Just remember the principles of a vlookup and it becomes a whole lo
easier. You are trying to look up a reference, either a fixed (i.e
typed in) or a cell and you are trying to find that in the left mos
column. Then you are looking to return a value X columns away.

Simply speaking if you were looking for “Car” in this table

Car 1
Bike 2
Train 3

You would look for “Car”, in the above table, 2 columns along. Thi
would look like = vlookup(“Car”,A1:B3,2,false). This assumes the tabl
starts in cell A1. The false at the end means find the exac
reference.

If you have any other questions just shout
 
Back
Top