Clueless as to how to write VLOOKUP formula

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.

Originally Posted by 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.

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.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"moodwalker" <[email protected]> wrote
in message news:[email protected]...
>
> 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.
>
>
> --
> moodwalker
> ------------------------------------------------------------------------
> moodwalker's Profile:
http://www.excelforum.com/member.php...o&userid=24055
> View this thread: http://www.excelforum.com/showthread...hreadid=376598
>

Just remember the principles of a vlookup and it becomes a whole lot 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 most 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. This would look like = vlookup(“Car”,A1:B3,2,false). This assumes the table starts in cell A1. The false at the end means find the exact reference.

If you have any other questions just shout.