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
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