VLOOKUP

  • Thread starter does anyone understand VLOOKUP?
  • Start date
D

Don Guillett

Have you tried HELP index for LOOKUP and then looked at lookup, vlookup,
hlookup?
 
I

Ian Webb

-----Original Message-----
Can someone explain VLOOKUP to me?
.
Vetical lookup.
Click to expand...

This function looks for data held in a CELL in the left-
hand column of your current spreadsheet (This is the 1st
argument requested in the formula) and matches it with
the same data in the left hand COLUMN of another
spreadsheet(This is the 2nd argument requested), to do
this double click to select the whole of the other
spreadsheet you have open.
You then specify which column of the other spreadsheet
the data you require is in(this is the 3rd arument
reuqired), for example if you want data in column C of
the other spreadsheet you would enter 3.
If you need and EXACT match for the data in the left hand
column you enter FALSE as the 4th criteria. Then press
enter to complete the function.

Please note: the strings of data you are searching upon
should be in the left hand column of each spreadsheet and
be in numeric/alphabetic order.

The formula you have now created in one cell can now be
copied/pasted or dragged down the rest of the column of
the current spreadsheet.

If you now need to use this data for other functions or
to send to another person, I would advise you "copy/paste
special/values" the new column you have created. This
changes the data from a link to the other spreadsheet
into fixed value/text in your current spreadsheet.

The HLOOKUP fuction does the same thing, but for a,
HORIZONTAL, row of data.

Hope this helps,
Ian
 
Top