V lookup Problem

You give this formula: vlookup("Profit & Loss",Chennai,2,True) or

if the name in first column is matching in all respect use, vlookup("Profit & Loss A/c",Chennai,2,False)

Hi Santosh, I think u r having some problem in putting the formula, so try not to put the formula manually rather try from the list of given functions, select the lookup value column and  look range and select the number of the column properly. I think it will work. One can copy the sheets in one file and then try it will be easy.

Thank You...

Dear, If you show a sample file, then members would be able to help you.

However, let me tell you that the formula you mentioned is incorrect, and correct formula may only be suggested after analysing the situation.

Regards,

Desperado