i have a sheet showing an order number and it availablility:

Order Number Status
BIO10001 In Use
BIO10002 In Use
BIO10003 Available
BIO10004 Available

etc etc

This sheet is a 'tool' for the main sheet where users allocate order numbers
to a specific order, they choose the next available order number from the
next 'Available' one as above. The 'Status' is set by using a COUNTIF which
displays in results in a hidden field. Then the 'Status' field it is is based
on =IF(I114=1,"In Use","Available")

What i would like is to display the next available order number on the main
sheet, say in a cell at the top i.e "The Next Available Order Number is" my
question is how do i get excel to display the next 'Available' order number
from my list automatically

A1 and B1 are column headers. A2:B5 is number and status:

=INDEX(A2:A5,MATCH("available",B2:B5,0))

Biff

"Steven Brookes" wrote in message
...
i have a sheet showing an order number and it availablility:

Order Number Status
BIO10001 In Use
BIO10002 In Use
BIO10003 Available
BIO10004 Available

etc etc

This sheet is a 'tool' for the main sheet where users allocate order
numbers
to a specific order, they choose the next available order number from the
next 'Available' one as above. The 'Status' is set by using a COUNTIF
which
displays in results in a hidden field. Then the 'Status' field it is is
based
on =IF(I114=1,"In Use","Available")

What i would like is to display the next available order number on the
main
sheet, say in a cell at the top i.e "The Next Available Order Number is"
my
question is how do i get excel to display the next 'Available' order
number
from my list automatically