Understand VLOOKUP Formula

 thanx

absolutely very nice one.

thanks.

 

with regards,

c.a.nish*t doshi

Originally posted by :Mayank Ahuja
" nice presentation..........
 
Thanks
 
But there is my 1 query:
When we put vlookup in one cell "W" in your example.. Do we have 2 set formula of vlookup in each cell separately (in s, gaurav, t, h, as so on)......OR we can drag the cell 2 copy the remaining cell..
Is there any shortcut for the same?
 
I hope u understand my query......
 
pls reply
"

you can drag the formula but you have to make few corrections like column no. given after series address has to be changed.

good one Prakash, pl provide easy way to understand HLOOKUP. Thanks.

thanks, any one have a file to understand table & index in ms word. in insert menu.

thanks.............keep it up prakash

 thanks 

SORRY I AM NOT UNDERSTANDING

See this file.. You will new ideas to use Vlookup Function.

/share_files/vlookup-new-usage-3240.asp

ok i understood  VLOOKUP formula 

whats about HLOOKUP i met problem with this while working 

can you assist me on this 

 

sri..

Srinath ji Hlookup formula for you

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details