software

I have columns
Status Date Order#

I have a status column, that is either OPEN, or blank (for closed) for
each order #.

say i have order#1,2,3. order #1 and #3 are open. From the quot;arrayquot;??
shown:
Status Date Order#
Open 12/12 1
12/13 2
Open 12/14 3

I want to return a list that looks like:

1
3

rather than

1

3

does that make sense??

I tried the vlookup, but it didn't work out for me, perhaps wrong
syntax and such. Here's how it looked,
=VLOOKUP(quot;Openquot;,A:C,3,FALSE)....In this case it returned the first open
order # and nothing else

and i also tried,
=VLOOKUP(quot;Openquot;,A1:C1,3,FALSE).... in this case it returned an #N/A
until the first open order.--
beechum1
------------------------------------------------------------------------
beechum1's Profile: www.excelforum.com/member.php...oamp;userid=30489
View this thread: www.excelforum.com/showthread...hreadid=502650
ummmmmm... just bad timing, or does everyone hate me??--
beechum1
------------------------------------------------------------------------
beechum1's Profile: www.excelforum.com/member.php...oamp;userid=30489
View this thread: www.excelforum.com/showthread...hreadid=502650See www.cpearson.com/excel/noblanks.htm .

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;beechum1quot;
gt; wrote in
message
...
gt;
gt; ummmmmm... just bad timing, or does everyone hate me??
gt;
gt;
gt; --
gt; beechum1
gt; ------------------------------------------------------------------------
gt; beechum1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30489
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=502650
gt;