Looking up a value in an array

[Sherman8r44]

Hey guys,

I have two arrays; let's call them List1 (column A) and List2 (column B) and let's say they're each 100 characters long. I'm trying to find, for each value in List1, IF there is a matching value in List2.

So far, my approach is to return a "Yes" in cell C1 if, say, A1 has the same value as B1:B100. And then I could extend this down column C for each corresponding A. I tried an IF function with an OR in it, but I realized that OR doesn't work for arrays. Is there an easier way to do this?

[Ron Coderre]

Perhaps something like this....

This formula returns YES if the Col_B item exists in the Col_A list

Please Login or Register  to view this content.

Copy that formula down as far as you need.

Is that something you can work with?

[Sherman8r44]

Perfect! Thanks, Ron!