This doubt is from the november 2007, paper 2 , step 49wherein you need to export a query as .csv. After this is done u need to open the file in excel and use a lookup function for a cell that contains initials and replace them with their full names. The problem is that the lookup value is the initial in the cell itself. So when I write the formula, it gives an error of circular reference. So how is it supposed to be done??? I've got my paper tomorrow. Please don't say this is not in the paper. I really don't want to know what's there and what's not. Please tell me how to do this.
Thanks