Matching

[Steve2718]

I am looking for a formula that will look at a set of numbers with numbers and letters and see whether that exact match is there in another set of numbers.

I have tried Isnumber(match(A3,G:G,0)) however it does not appear to work.

any help appreciated.
Thanks
Steve

 

[T. Valko]

I am looking for a formula that will look at a set of numbers with numbers and letters and see whether that exact match is there in another set of numbers.

I have tried Isnumber(match(A3,G:G,0)) however it does not appear to work.

any help appreciated.
Thanks
Steve

Can you be more specific?

Do you get an error? An incorrect result?

Show us some typical data.

What's in A3?

Let's assume you think there's a match with A3 and G10. What result do you get with this formula:

=A3=G10