Search cell text and output different values based on result in another cell

Hi there!

New to the forums and somewhat to excel functions. Any help is greatly appreciated!

I'm trying to search text within cells in column A and return a price to column B based on the search. Example file attached. I've tried everything I could find on other forums but nothing seems to work quite right.

I think a formula structured like this should work but I assume the language is incorrect to be able to search within a text string.

=LOOKUP(A2,{0,60,70,80,90},{"F","D","C","B","A"})


Sample.xlsx

Thanks again for the help!

My bad!

I need to search by "4FT X 4FT-VINYL", "4FT X 4FT-POLYPAPER", etc. Each size/material will be given a price either set in the formula or can be pulled from a column within the sheet. I don't know what's easier or would work better. Open to suggestions. The attached example will have a total of 12 unique prices.

I've finally found a formula that works, but will end up being very large once I incorporate in the 52 total search terms and corresponding prices.

How can I condense this:
=LOOKUP(2^15,SEARCH({"4FT X 4FT-VINYL","4FT X 4FT-POLYPAPER","4FT X 4FT-CANVAS"},A2),{"10","20","30"})

Thanks!