Need help in VLOOKUP comand

A

ashishprem

Hi,
I m beginner in exce formulas. Can someone help me out in understandin
the VLOOKUP formula especially the meaning of column_index_num.
Regards,
Ashis
 
M

mr_ben

Beleive it or not the help content in excel is very good on thi
however......


a Brief explanation


The lookup value always has to be in the first column of the dat
you're looking into.

The column index is the column that you want where the relevant dat
you require is held.

column 1 = the looked up value
column 2+ = the rest of the data

therefore if you have a data table that goes across 9 columns(ie A- I)
and the data you want is in column F the coloumn index number would b
6.

Always make sure that IF your table data ISN'T sorted then you ad
FALSE in the range_lookup, this way it will not fail.




HT
 
N

Niek Otten

Here's a tutorial:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Hi,
| I m beginner in exce formulas. Can someone help me out in understanding
| the VLOOKUP formula especially the meaning of column_index_num.
| Regards,
| Ashish
|
|
| --
| ashishprem
| ------------------------------------------------------------------------
| ashishprem's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31485
| View this thread: http://www.excelforum.com/showthread.php?threadid=569368
|
 
Top