MS Excel

ranjan

Accounting Officer

43 Points Posted on 01 October 2007

Syntax for v lookup in Excel

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Anand

Manager - Finance

53 Points Posted on 01 October 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 Posted on 01 October 2007

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

Ravikumar.G

Consultant

18525 Points Posted on 01 October 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 Posted on 03 October 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

459680 Points Posted on 10 October 2007

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 Posted on 20 November 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.