Lookups

[kandyudayan]

1) Issue # 1 (How can I avoid duplicates in drop down.
2) Formula in I2 for getting total income for selected category in H2

 

[arthurbr]

Perhaps use a simple Pivot Table?

 

[Logit]

In H2 use :

=UNIQUE(C2:C1000)

Then change your Data Validation source to C2

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Logit]

Disregard my previous response.