V lookup Problem

santhosh (CA) (636 Points)

25 February 2010  

Hi there

 

I am now involved in consolidation of Trial Balances of various branches to arrive at final trial balance..

I have the TB in Excel sheet.. I am using Vlookup function to consolidate.

I have named all the TB properly using (define name) in the excel sheet.Now when i add all using vlookup function the results are of errors.. for example if i input vlookup(Profit & Loss,Chennai,2,True) then excel gives value of Deposits (NOT PROFIT & LOSS A/c ) in chennai TB.

How do i rectify this...?

Urgent 

THanks...