vlookup

A

Arvin Meyer [MVP]

girish24 said:
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.
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top