Frantheman
02-15-2013, 03:32 AM
What function or VBA code could work for this little problem?
I have the following list:
A2:B5
I need a function in 'Sheet2" A2 that says if anyone of A10:A14 = A2 then B2 or A10:A14 = A3 then B3 or A10:A14 = A4 then B4 or A10:A14 = A5 then B5. Also we need to exclude duplicates e.g. if sesame and almonds occure it should say Seds and not Seeds,Seeds ut if Sesame and Crab occur it should say Seeds, shelfish.
See attached sheet.
I have the following list:
A2:B5
I need a function in 'Sheet2" A2 that says if anyone of A10:A14 = A2 then B2 or A10:A14 = A3 then B3 or A10:A14 = A4 then B4 or A10:A14 = A5 then B5. Also we need to exclude duplicates e.g. if sesame and almonds occure it should say Seds and not Seeds,Seeds ut if Sesame and Crab occur it should say Seeds, shelfish.
See attached sheet.