Hi
I have got the following table. Now I want to bring the amount of GRRs in the other file in which there is a list of GRR Nos. But if you observe, for example, GRR No 1215 appeared twice having two different amounts. So while applying the vlookup in the other workbook I need to get the sum of...
I had converted the Pivot Table data to normal range & then tried to apply the sum formula on the amount column. But the output returned is 0 (zero). I tried everything like, I converted text to General etc but still my formula is not working.So can anyone help me on this issue