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.
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 |