I have 3 columns that are checking item sku designations and determining if
the come in different materials. I need a 4th column to return which material
it comes in...

1 2 3 4
LAM VINYL PLASTIC AVAILABILITY
TKC-LAM #N/A #N/A ?

How can I get this to work?