gp
Blogger
0
1062

# Vlookup

Vlookup

• ### Statement of Capital

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).

Thanks.

### Replies

26th Feb 2012 00:25

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.

Thanks (0)
By gp
to Michael C Feltham
26th Feb 2012 11:29

Vlookp

Table 1

CodeAmount32650025018078230000180326707501507824502508078240

Table2

CodeAmount001 250 326 750 782

The question is how to Lookup for code in table 1 and sumup in Table 2 for the same code?

Can you please provide me the formula?

Thank you once again for your help.

Thanks (0)
By gp
26th Feb 2012 11:58

Thanks

Sumif() formula work with this. Great!!!