Excel: compare array help

I tried doing this in a simple isnumber-search, but i have over 64 cells to compare. - this worked for my other project that was only like 40. I need to see if any of the values in column b are in column a then return column c into column d i tried vlookup, lookup and stupidly a simple search. Any clue how to do this? -- I'm not into vba right now no need to get into it either. Thanks

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of March 03, 2014.

For more resources for Microsoft Excel