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

MS Excel

Excel 2433 views 11 replies

ravi

articled assistant

50 Points Joined September 2007

pls let me know the syntax of v look up in MS Excel.

Replies (11)

ranjan

Accounting Officer

43 Points Joined September 2007

Syntax for v lookup in Excel

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Anand

Manager - Finance

53 Points Joined September 2007

Hi Ravi, U can find the details in the Insert tab under the functions. you can get the Syntax of all the formulas used in Excel.

CA. Dashrath Maheshwari

TaXpert

15126 Points Joined September 2007

H-lookup is another good fomulae that you can find more important

Ravikumar.G

Consultant

18525 Points Joined March 2007

/files_display.asp?files_id=1939 want to see more excel functions down load it from our files portal using the above path.

Kamaraj Mani. N

Chartered Accountant - Product Manager

553 Points Joined September 2007

Mr. ravi,

Please tell your exact need....

this syntax you can get easily from Excel help file...

can you please tell us your exact need on it...

Guest

450255 Points Joined August 2012

Hi I am Rami Reddy, I would like to know where can I get all excel commands . I hope to get the information from the members

Kamaraj Mani. N

Chartered Accountant - Product Manager

553 Points Joined September 2007

Mr. K.L. Rami Reddy,

'Excel Commands' means you are asking about Excel Functions, right?

If my view is correct, All the formulas and the explanation as how to use the same are available in MS-Excel itself.

You can use this Navigation: INSERT>FORMULA.

If my view is WRONG, Please specify the exact need.