I have been given a list of firms and the rating of each. I need to have a formula, so for each row the firm will have a rating. I cant manually type each rating in, because there are around 40,000 rows, so it would take a while.

I tried to do an IF function, so for example every time a certain firms comes up, the rating would be A, but there are about 20 firms that have this A rating, and the function didn't work.

I have tried to show what I mean on the attachment.

ABC.xlsx

Thanks