See either mine or Julie's last posts for a VLLOKUP solution. Lots of free
templates to be had on the MS site as well.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Margaret" wrote in message
...
Thanks for your help, Ken. I am not sure how to write greater than or
equal
to and am not sure what to do if I have multiple inequalities.
If I have multiple inequalities for a row would I write the following:

=IF(AND(xOR=20,x<40),5), (IF(AND(xOR=40,x<60),6)),(
IF(AND(x=OR60,X<80),7))

Thanks,
Margaret
"Margaret" wrote:

How do I write an inequality in excel? For example, if 20<x<40 then
write 5
in the