Thank You for the prompt responses. Unfortunately Mudface I am not familiar with Colo's HTML. But I will provide this data:
What I'm basically doing is imputting data in excel then pasting it into a different loging program. So in my spreadsheet if I type in Black in cell F2, it knows that the cell N2 should have the number 1 (signifying Library colour and symbol 1)
Cell N2:
=IF($F2="Black",1,IF($F2="Green",3,IF($F2="Orange",5,IF($F2="Blue",7,IF($F2="Grey",8,IF($F2="Red",2,IF($F2="Yellow",4,IF($F2="Magenta",15,"EDIT"))))))))
Then in cell O2 it knows black can be found in Log Library.
Cell O2:
=IF($F2="Black","Log Library",IF($F2="Green","Log Library",IF($F2="Orange","Log Library",IF($F2="Blue","Log Library",IF($F2="Grey","Log Library",IF($F2="Red","Log Library",IF($F2="Yellow","Log Library",IF($F2="Magenta","Log Library","""EDIT"))))))))
What I'd like to do is add several more colours and/or symbols to the statements but as you have told me there is a limit. Maybe what I should do is read up on VLOOKUP I wasn't aware of this function.