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
19 September 2026
Finance Manager

Mugdha Art Studio

Hyderabad

CA

View Details
Company
07 October 2026
Senior Account Manager

Amplio Invest

Mumbai

M.Com

View Details
Company
Featured 03 October 2026
Accountant

A P Lodha and Associates

Jalna

B.Com

View Details
Company
ARTICLESHIP 18 September 2026
Industrial Trainee

Twenty Point Nine Five Ventures Private Limited

Noida

CA Inter

View Details
Company
ARTICLESHIP 30 September 2026
CA Article Assistant

CA Suraj Garg & Associates

New Delhi

CA Final

View Details
Company
ARTICLESHIP 01 October 2026
Articled Assistant

KPSN & Associates LLP

Chennai

CA Inter

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured ARTICLESHIP 06 October 2026
Semi Qualified

AJAY SINGH AND CO LLP

Thane

CA Final

View Details