gp
Blogger
Share this content
0
4
1010

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.

Replies

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.

Thanks (0)

Vlookp

Thanks for your help.

Please find below the sample

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)

Thanks

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

Thanks for your help.

 

Thanks (0)

Pivot

I think a pivot table would work better here.

Thanks (0)