What is the formula?

[pakplan11]

I want to know the formula for the following example;


I want to be able to select the following in the range of M2 through M30

100%:

90%:

80%:

70%:

60%:

50%:

40%:

30%

20%

10%:

10%:

0%

<tbody>
</tbody>

If i select any of the %'s from MY COLUMN M above, I want the following to auto populate in N2 and O2 respectfully;

100%:	WON	Customer has sent PO and PCM-G has processed
90%:	Decision	AE has met with ALL decision makers and waiting on PO. Proposal in purchasing
80%:	Decision	Paperwork, proposal through legal, negotiating complete, going to purchasing
70%:	Decision	Completed paperwork process and any outstanding technology issues, pricing, paperwork in legal.
60%:	Decision	Selected PCM-G and technology proposed, begin negotiations of pricing,
50%:	Evaluation	Evaluation stage. How is the decision made to purchase?
40%:	Proposal	Quote created, pricing and timeframe determined. Evaluation established including expectation of timeframe and next steps.
30%	Qualifying	NSP-Deal Registration is approved by the MFG
20%	Qualifying	1) AE completed meeting or conference call 2) AE Identifed project is budgeted 3) AE Identified purchasing process (what has to happen internally at the customer to obtain a PO) 4) AE has identified legal contacts and procurement contacts for succesful close 5) AE has contacted MFG partner for deal registration and opportunity
10%:	Prospecting	Meeting or conference call scheduled, purpose is to identify requirements through a round table or white board discussion.
10%:	Prospecting	A lead, cold call attempt, vendor lead, general interest in a project.
0%	Lost	Lost

<tbody>
</tbody>

In the end M = the the percentage column, N= the WON, Decision, Qualifying etc column and O = the text description THANKS FOR YOUR HELP!~!!

<tbody>
</tbody>

 

[Joe4]

Set up a lookup table and use VLOOKUP.
See: https://www.techonthenet.com/excel/formulas/vlookup.php