Dear All

Please see the attached file name TESTTest.xls, Here values in Summary sheet see column AL i am using lookup to get Description for the cost head from Sheet1. Now my problem is in some of the cells see AL26 the result is Zero, i dont know why this is coming zero here, i tried all tricks but could not get rid of this.

Secondly, while i am using LOOKUP here i want to have a similar formulae to be able to match to the item in Column AK, in Summary with Table A:D (sheet1) and return values from column F.

Any response to this would be appreciated

Best regards

Pranab Deb