lookup with uneven columns


M

meehanbrian

Hi I am searching through 2 uneven columns, column A with ~1500 rows
and column B with ~250 rows.

Column A is obviously much more inclusive, but I need to know if an
entry in column B appears anywhere in column A. I'm looking for a
function/macro that can be written-and-edited to search for an entry in
both column A and B.

ctrl+f is painful and an IF function is not practical with 250 rows,
let alone editing it and pasting down 1500 rows each time it is edited.

Any help is greatly appreciated!

B
 
Ad

Advertisements

T

T. Valko

Maybe something like this:

Enter in C1 and copy down to the end of the list in column B:

=IF(ISNA(MATCH(B1,A$1:A$1500,0)),"","Match")

Biff
 
M

meehanbrian

Biff you are wise....many thanks

B

T. Valko said:
Maybe something like this:

Enter in C1 and copy down to the end of the list in column B:

=IF(ISNA(MATCH(B1,A$1:A$1500,0)),"","Match")

Biff
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Uneven Columns 2
Column Lookup? 3
multiple column lookups 1
Lookup across columns 3
Lookup in multiple columns 7
two column lookup 3
Two-Column Lookup 2
two-column lookup 7

Top