I have my order form so that when a user enters the product number, the
product information will display in the appropriate spaces (i.e., the full
description of the product). Here's the formula I'm using:

=LOOKUP(L20,Products!$C$2:$C$85,Products!$B$2:$B$8 5)

However, the spreadsheet gives incorrect information when it sees text in on
the PRODUCTs sheet. An example:

colb colc
toys 2848395
horses 8392879
houses see price list
rugs 8237499

If I type in the 'rugs', it produces the 'see price list'. Can anyone tell
me how to correct this?