Aplication of Vlookup or any lookup

[caprashant]

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 GRR amount against GRR no 1215 which is 8000/-. Right now when I apply vlookup, it takes GRR amount 5000/- which appears first in the table. So my query is how can we bring either of the three values i.e either 5000 or 3000 or 8000 (sum of GRR no 1215)

Can anyone help me?


GRR No Amount

1215 5000

1546 2000

1489 1458

7894 74000

4153 4516

1215 3000

1546 4000

7894 3000

 

[shrivallabha]

If you want to see the combined total then you don't need a LOOKUP function but a SUMIF.

e.g.

=SUMIF(Sheet1!$A$2:$A$10,A2,Sheet1!$B$2:$B$10)

Where Sheet1 has data you've posted above!