Vlookup
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.
Try using