Lookups on 2 criteria

[certain_death]

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

[DonkeyOte]

Assuming single match

Please Login or Register  to view this content.

If you have multiple matches the above will return the last match whereas the below would return the first

Please Login or Register  to view this content.

[certain_death]

Many thanks Donkey

Thanks brilliant

Regards
**