List "OPEN" orders based on a status column

  • Thread starter Thread starter beechum1
  • Start date Start date
B

beechum1

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return column header based on last value in row 3
Using ISNA on more than one column within an If Function 2
Referring to a cell by using another cell for the row number 6
Sorting day names chronologically 5
Checking data in 2 columns against a further 2 columns.... 1
Sumifs - incorrect when using date in critera 3
Multiple Column Sorting 2
Final Status 1

Back
Top