Go AD-Free with CAclubindia Pro and Daily Mobile Updates. Subscribe Now!

Understand VLOOKUP Formula

CA CS CIMA Prakash Somani (Landmark Group) (23512 Points)

23 November 2009

Reply
Follow
Share

25 Replies

Saikat Bhattacharya (Manager- Finance and Accounts) (131 Points)
Replied 23 November 2009

Sorry ..Unable to understaing from the excel sheet attached by you.

L KANAGARAJ (Assistant Manager-Finance) (615 Points)
Replied 23 November 2009

Thanks & u r correct.

(Guest)

Nice one Mr. Prakash...Look forward for new topics..!!

CA CS CIMA Prakash Somani (Landmark Group) (23512 Points)
Replied 23 November 2009

I dont think there should be any problem in understanding the Vlookup formula from this file as this is the simplest way i can make you understand about this formula :)

Let me know if any query :)

(Guest)

Thanks.

(Guest)

GREAT ONE

The Harshit Aggarwal (B.Com(H) ,CS Final) (5278 Points)
Replied 23 November 2009

gud one

(Guest)

Thanks for sharing.....

LAKSHMI NARAYAN (CA Final Student) (904 Points)
Replied 23 November 2009

Very Good prakash!!. Clear and neat Explaination in simply terms.

Keep going and teach us some more.

(Guest)

Thanks

CA PRIKSHIT WADHWA (CHARTERED ACCOUNTANT) (339 Points)
Replied 23 November 2009

GUD JOB PRAKASH

(Guest)

thanks

C.A Akash Gupta (C.A ICWA Final CS Professional) (242 Points)
Replied 23 November 2009

thanks............

Mayank Ahuja ("Learner") (586 Points)
Replied 23 November 2009

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