no im not...im using an older excel i think...its 1997 excel..its the only one my company is running off of.

my code is =LOOKUP(critical, Range,column)

or basically =LOOKUP(cell of validation list, range of choices, range of answers)

how else can i do this?