| 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") |
| 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 | |||
Threaded Mode
