| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using the If or lookup statement to find matches
I have a column of 35 values and I need to find if any of these values match
the values in another coloum of 400 values and if so to return a True. I tried this but to no avail. =IF(A2..A35= B2..B400, "True", "False") |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the If or lookup statement to find matches
=COUNTIF($B$2:$B$400,A2)0
copy down Regards, Peo Sjoblom RocketMan wrote: I have a column of 35 values and I need to find if any of these values match the values in another coloum of 400 values and if so to return a True. I tried this but to no avail. =IF(A2..A35= B2..B400, "True", "False") |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the If or lookup statement to find matches
Wow, great! it worked like a charm. Thank you
"Peo Sjoblom" wrote: =COUNTIF($B$2:$B$400,A2)0 copy down Regards, Peo Sjoblom RocketMan wrote: I have a column of 35 values and I need to find if any of these values match the values in another coloum of 400 values and if so to return a True. I tried this but to no avail. =IF(A2..A35= B2..B400, "True", "False") |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using the If or lookup statement to find matches
Thanks for the feedback
Peo RocketMan wrote: Wow, great! it worked like a charm. Thank you "Peo Sjoblom" wrote: =COUNTIF($B$2:$B$400,A2)0 copy down Regards, Peo Sjoblom RocketMan wrote: I have a column of 35 values and I need to find if any of these values match the values in another coloum of 400 values and if so to return a True. I tried this but to no avail. =IF(A2..A35= B2..B400, "True", "False") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return blank cell if 'find' statement not true | Excel Worksheet Functions | |||
| Lookup Value and find Corresponding Value on another row same column | Excel Discussion (Misc queries) | |||
| Find and replace with a lookup | Excel Worksheet Functions | |||
| Find certain text in a column and return statement | Excel Worksheet Functions | |||
| Where can I find a Billing Statement Template for Word or Excel? | New Users to Excel | |||
Hybrid Mode
