For my vlookup question let me set one example
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?