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.

 

 

Comments
There are 4 comments. Login or register to view them.

Try using

wockywocky |
wockywocky's picture

Vlookp

gp |

Thanks

gp |

Pivot

neileg |