vlookup

[girish24]

how to use vlookup fuction on ms-excel.

 

[Arvin Meyer [MVP]]

how to use vlookup fuction on ms-excel.

Your question may be better answered in an Excel newsgroup which will be
appropriate to your problem. This newsgroup is dedicated to the Microsoft
Access database product. The Microsoft website may have misdirected you.

 

[NevilleT]

You are asking in the wrong place. Please use the Excel newsgroup.
Neville Turbit
www.projectperfect.com.au

 

[POINTBLANK0704]

"girish24" wrote in message
news:[email protected]...
> how to use vlookup fuction on ms-excel.

Your question may be better answered in an Excel newsgroup which will be
appropriate to your problem. This newsgroup is dedicated to the Microsoft
Access database product. The Microsoft website may have misdirected you.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com[/QUOTE

=vlookup(Select the cell you want to lookup,select the ranges you want lookup to look into, enter the column # your data is in,True or False) usually the last section is False. This is all in the VB Help file also, click on help then type vlookup and an example is there for you.

 

[jayensmi]

how to use vlookup fuction on ms-excel.

try this site: http://www.bappit.com/Excel.html

 

[Satya Nanduri]

=VLOOKUP("Look-up Value",Range or an array,Column Index No,range lookup)
Example: (range say d12 to g15)
apr may Jun
store-1 100 250 400
store-2 150 350 600
store-3 500 800 300

Following formula will return a value of 600 (that is the value for store-2
in column 4.

=VLOOKUP("Store-2",D12:G15,4,0)

HOpe this helps.