Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

MS Excel

ravi (articled assistant) (50 Points)

01 October 2007

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

Reply
Follow
Share

11 Replies

ranjan (Accounting Officer) (43 Points)
Replied 01 October 2007

Syntax for v lookup in Excel

=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Upgrade to CAclubindia Pro. Subscribe Now!

Anand (Manager - Finance) (53 Points)
Replied 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) (15103 Points)
Replied 01 October 2007

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

Ravikumar.G (Consultant) (18525 Points)
Replied 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)
Replied 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...

Upgrade to CAclubindia Pro. Subscribe Now!

(Guest)

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)
Replied 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.