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 "array"??
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("Open",A:C,3,FALSE)....In this case it returned the first open
order # and nothing else

and i also tried,
=VLOOKUP("Open",A1:C1,3,FALSE).... in this case it returned an #N/A
until the first open order.


--
beechum1
------------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=502650

ummmmmm... just bad timing, or does everyone hate me??


--
beechum1
------------------------------------------------------------------------
beechum1's Profile: http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=502650

See http://www.cpearson.com/excel/noblanks.htm .

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"beechum1"
wrote in
message
...

ummmmmm... just bad timing, or does everyone hate me??


--
beechum1
------------------------------------------------------------------------
beechum1's Profile:
http://www.excelforum.com/member.php...o&userid=30489
View this thread:
http://www.excelforum.com/showthread...hreadid=502650