compare array help

[Tootlez]

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

 

[Aladin Akyurek]

So it ends up being nearly the same - between the two of you.

Thanks for the help! Sorry to be confusing. But I'm glad I got it figured out

Addendum:

http://www.mrexcel.com/forum/excel-questions/724843-there-case-sensitive-vlookup.html#post3568323

 

[markmzz]

So it ends up being nearly the same - between the two of you.

Thanks for the help! Sorry to be confusing. But I'm glad I got it figured out

I'm happy that your problem was solved and to help too.

Markmzz