hi all

Can someone help with a formula on this please

I want to say if column A = Shoes, column B = Market data, then give me the code for column C.

Please help. (example below).

Thanks
**


A B C
Shoes Market Data 01-20-232-193
Socks Market Data 01-20-200-193
Sandals Market Data 01-20-203-193