Linking data in columns

a lookup table would also work. Say you have 20 toys, list those in column E, row 1 through row 20. In column F, list the appropriate Y or N.

In column B, row 2, put the formula:

=vlookup(B1,$E$1:$F$20,2,FALSE)

then copy that down column B

Thanks for the tips. I have lots of different toys and keep on adding new ones all the time. I think I will have to create a new sheet in the workbook and create the table with CDN indicators and use the vlookup function.

One more question though, say I were to implement that. Iin the main sheet, where I enter the toys, is there a way that ensure that the title entered matches my separate titles sheet?

Thanks in advance.

If it doesn't match, you'll get an "#N/A" where the lookup formula is. If you are doing data entry into that column A, your entry should self-complete after the first few characters are typed, if you have already entered that toy at least once in that column.

Thanks, that answered my questions!