Sorry if something similar has been asked before, I didn't know exactly what to search for so I thought I'd try an ask.

I work in printing, and in one column of my excels I create for work I'll put in the name of one of the clients I work with. In another column I would love that client's postcard size to auto-populate because each client's size is always the same (and it's hard for me to remember each one off hand.)

So for example, if cell A3 says 'Ford' I'd like cell B3 to automatically list '6x9'. If cell A4 says 'Muse' I'd like cell B4 to automatically list '5.5x8.5' etc. I have over a dozen clients though, and each one is different so I'm not sure this is something Sheets can do for me or not?

Appreciate any help! Thanks :)