vlookup

[djackson]

Can someone please help with the vlookup formula. I have rea
information on this but still do not get the main grasp. Maybe a
example or a breakdown for a new user of this function.

Thank

 

[Frank Kabel]

Hi
have a look at
http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[Stefan Hägglund [MSFT]]

Hi!

You can read about vlookup at http://support.microsoft.com/?id=181213

Stefan Hägglund
Microsoft

 

[Norman Harker]

Hi djackson!

Apart from following the links given by Stefan and Frank, try posting
details of what you are trying to do. It might even be that VLOOKUP is
not what you need.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[sandra]

Hi,
This is something I successfully used for the first time
not long ago. vlookup allows you to "pull" data from
another spot, returning it to the cell where you've got
the formula.

So, say you've got a spread sheet with the following:

ColA ColB ColC
john smith 123 any st some town, usa
joe average 456 avenue

 

[sandra]

Oops, sent by accident before finished, see below...

-----Original Message-----
Hi,
This is something I successfully used for the first time
not long ago. vlookup allows you to "pull" data from
another spot, returning it to the cell where you've got
the formula.

So, say you've got a spread sheet with the following:

ColA ColB ColC
john smith 123 any st some town, usa
joe average 456 avenue anytown, usa

on another sheet you could use vlookup to fill in info on
either john or joe. You can use any of the columns for
your initial point of reference to pull info from the
remaining two.

Hope that helps

 

[CLR]

A Google search for "VLOOKUP" will return numerous hits with graphic
explanations of the function......much better than I could give here in
text.

Vaya con Dios,
Chuck, CABGx3

 

[Andy Wiggins]

There are very good examples in the Excel Help file.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[djackson]

thanks by the information provided I believe I now have the basi
vlookup knowledge.

Thank