Hi, have been breaking my head on this, i think it's simple, but can't seeem
to figure it out:

I have a list of songs. There are three types of songs - fast, medium and
slow.
These have already been categorized and put into columns with headings of F,
M and S.

What i need is, whenever i paste songs into an excel sheet i need the column
after that to show automatically F, M or S using my categorized list as a
reference.

I've tried using IF, but am not able to use it with a range i.e the
categorized columns. Or am i off the mark? Should i convert the list to 3
different databases or something?

Please help... :(