Gary,

I tried your formula and the returned was #N/A. I have a range of text in
A2:A81 and I want to convert the text in tec cell of the rantge to a number
in another range of cells P2:P81. Example A2 has the text of Heat and I want
P2 to be 1. Any suggestions.

Tom

"Gary''s Student" wrote:

With a word in A1:

=LOOKUP(A1,{"none","one","two","three";0,1,2,3})


--
Gary''s Student - gsnu200823


"Tom" wrote:

How can I convert a text word (i.e. None) to a number (i.e 0)?