Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup with uneven columns
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup with uneven columns
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 wrote in message ps.com... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup with uneven columns
Biff you are wise....many thanks
B T. Valko wrote: 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 wrote in message ps.com... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup with uneven columns
You're welcome. Thanks for the feedback!
Biff wrote in message oups.com... Biff you are wise....many thanks B T. Valko wrote: 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 wrote in message ps.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL should let me establish unlimited numbers of columns. | Excel Discussion (Misc queries) | |||
Lookup Two Columns - Again | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Lookup function skipping columns | Excel Worksheet Functions |