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.

MEMBER ID	CUSTOMER NAME	CATEGORY
PV1234	JUAN
AN4321	JOHN
EN5412	FRED
FG4124	ANNA

<tbody>
</tbody>

Thank You and hope to hear from you soon.

 

[Aladin Akyurek]

Would you post 5 rows from that separate table?