Hi,
For my vlookup question let me set one example
A | Value |
---|---|
10 | 200 |
11 | 300 |
12 | 400 |
10 | 600 |
12 | 50 |
I used followin formula : Vlookup("10",A1:B5,2,False).
Which work ok but I am having 2 problems.
1. I don't want false statement if not matched, instead i want value 0 or no value.
2. Value 10 repeat so I want sum of two. i.e. add value if repeat (here 800).
Can anyone please help me out to write correct formula?
Thanks.
Replies (4)
Please login or register to join the discussion.
Try using
Sumif - to return the total of the results which should also give you a nil return too; if the nil return doesn't work you could start the formula with if(Iserror..
Hope that helps but if not pm me a sample of data and I will return it with the formulas.