Help with inventory table

Hello.

I'm looking for help with Excel inventory table.

In Collumn A, I have thousands of serial codes which look like this example 123456-78.
In Collumn B, I need to have names of colours "Black, Pink, Blue etc." which are determined by the last two numbers of the serial code.

I've tried using the IF function, which worked like a charm until now, but the company delivering the supplies to us started offering more colours, over 80 and the IF function can handle only 64.

Is there any way to do this without VBA?

Originally Posted by excelisfun009

Did you try adding the results of nested IFs?

Can you elaborate please?

You need to use the vlookup function for that. See example in attachment

Originally Posted by lode devos

You need to use the vlookup function for that. See example in attachment

This is perfect.
Thank you very much.