Vlookup

Vlookup

Didn't find your answer?

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 (4)

Please login or register to join the discussion.

avatar
By wockywocky
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)
Replying to Michael C Feltham:
avatar
By gp
26th Feb 2012 11:29

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)
avatar
By gp
26th Feb 2012 11:58

Thanks

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

Thanks for your help.

 

Thanks (0)
avatar
By neileg
27th Feb 2012 09:37

Pivot

I think a pivot table would work better here.

Thanks (0)