Required formula to find out category

[siroopm]

Helo,

I required a formula in column E to display the category(A) according to vendor column(B). Excel file attached. Please help.

Thanks -

[samba_ravi]

E4=

Please Login or Register  to view this content.

TRY THIS AND COPY TOWARDS DOWN

[AliGW]

In E4 copied down:

=IF(A4<>"",A4,LOOKUP("zzzzz",A$2:A3))

[Richard Buttrey]

Hi,

Put the word Mobile in A4 rather than A3 to make the data consistent. Then in E3 copied down

Please Login or Register  to view this content.

A word of advice. This is clearly a simplified example, but if you want to use your data for serious analysis then you should consider creating a proper normalised 2 dimensional table so that you can analyse it with a Pivot Table.

So once you've updated column E, can I suggest that you copy and paste back as values and then delete column A. When you add new data be sure to add the category as you enter each new row.

[siroopm]

Thanks Mr. Siva.. it works...

closing thread as solved.

[AliGW]

They all work, Mr Siroopm!!!

[siroopm]

Thanks everyone.