| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a value in one of two columns
Put this formula in C1 and then copy down as far as you like...
=IF(A1&B1="","",IF(ISERROR(SEARCH("A123",A1&B1))," No","Yes")) Rick "S Shipley" wrote in message ... I have a spreadsheet where column A contains 4 character department codes i.e. A123 and column B contains multiple 4 character department codes separated by commas. I want to find the value A123 in either column A or column B and if found put a Yes in column C and if not found then put a No in column C for that row. I have tried several different functions and combinations of functions but I can't seem to get reliable results. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding matches in two columns | Excel Worksheet Functions | |||
| Finding E-mails in different columns and trying to put them in one | Excel Worksheet Functions | |||
| Help finding the length of two different columns | Excel Programming | |||
| Finding difference between two columns | Excel Programming | |||
| Finding Max Within 3 Columns | Excel Programming | |||
Threaded Mode
