Can I use an IF function to display a certain number if a cell begins in a certain string?

Here is what I want to do:

If cell A1 begins in text "GR" I want cell B2 to display "5"
But I want to work with different numbers...so if cell A1 begins in "RSS" I want cell B2 to display "10"

Is this possible?

Originally Posted by 6StringJazzer

There are two ways to do this. If you have several different strings that you're looking for, it is better to set up a table and then use a VLOOKUP formula in B2. I can demonstrate if you provide your file.

The other way is to build it into a formula:

=IF(LEFT(A1,2)="GR",5,IF(LEFT(A1,3)="RSS",10,"Not found"))

Thank you, that worked perfectly.
Another question, if you are able to answer.

I have 2 worksheets in this file. The second one has a listing of product codes and descriptions on it. In the first one I want to type in the product code and have the description automatically generate in the next cell to the right. Is there a way to have it pull that description automatically from the second worksheet if the product code matches?

Yes. Either attach your file or provide the following information:

• Name of the second sheet (with product codes and descriptions)
• Column containing product codes
• Column containing descriptions