Formula says I have too may arguments.
=IF((B$10)="Robert","Green",IF((B$10)="Nerida","Pink",IF((B$10)="Jack","Black",IF((B$10)="Max","Red",IF((B$10)="Jim","Blue",IF((B$10)="Chris","Orange",IF((B$10)="Sarah","Yellow",IF((B$10)="Rose","Purple",""))))))))
I need to add: IF((B$10)="Wade","Aqua" and IF((B$10)="Steve","White" yet.
How can I do this.
Here:
why not create a table for that then you could refer using lookups?
Please Login or Register to view this content.
here a table sample..
used index and match
colortable.xlsx
then you can add names and colors to the table..
Last edited by vlady; 09-04-2012 at 08:51 PM. Reason: Inserting table
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Awesome, your a star, cheers vlady
Cheers.
Can you mark this thread "Solved".
Go to your first post, click edit then follow instruction below my signature line.
thanks.
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks