Formula Help

[baggarwal]

Hi All:

I have a simple database below. The user has to input PO or NO PO in column D. In column E I need a formula that will put in the sequence. So if the user change the No PO to PO then the sequence needs to be updated based on the order.

Then I need a formula to pull in data from column A based on the key in column E The formula in the current column is not working. Can someone please help.

Book1.xls
	A	B	C	D	E
4	Program	Tactics	Actuals	POstatus	Key
5	Advertisements	salesgrowth	500	PO	1
6	JournalAds	salesgrowth	600	NOPO	0
7	Consulting	salesgrowth	300	PO	2
8	Samples	salesgrowth	200	PO	3
9	journals	salesgrowth	600	NOPO	0
10
11
12	Desired	CurrentFormula
13	Advertisements	#N/A
14	Consulting
15	Samples
Sheet1

 

[KWMSeattle]

In your MATCH function, remove the quotes from the 1.

 

[baggarwal]

If I do that it returns a refererence error

 

[baggarwal]

Can someone please tell me a formula I can use to get the 'key' working. I just need help in making it dynamic based on the user input.

 

[KWMSeattle]

Interesting, it works for me. Let's take the formula 1 piece at a time. What is your result when you plug the following formula into cell B13?

=MATCH(1,$E$4:$E$9,0)

I'm getting a result of 2.

 

[baggarwal]

My appologies it works now.

Can you tell me how to get the formula for the key working?

 

[baggarwal]

Re: Count Question (Urgent)

Can someone please help me with setting up the dynamic key