Formula for multiple conditon

[Harold Garcia]

Sir/Mam,

I would like to request for a formula that will categorize my data. As seen on table below, i have Member ID and Category. what formula will i use to have the Category to identify VIP and REGULAR customer. i have separated table that have the list of MEMBER ID which is VIP.

[TABLE="width: 500"]
<tbody>[TR]
[TD]MEMBER ID[/TD]
[TD]CUSTOMER NAME[/TD]
[TD]CATEGORY[/TD]
[/TR]
[TR]
[TD]PV1234[/TD]
[TD]JUAN[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AN4321[/TD]
[TD]JOHN[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EN5412[/TD]
[TD]FRED[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FG4124[/TD]
[TD]ANNA[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thank You and hope to hear from you soon.

 

[Aladin Akyurek]

Would you post 5 rows from that separate table?