| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a value if item does not appear on list
I'm sure there is a way to do this with VLOOKUP or a similar function, I just
don't know how..... I want to compare two lists of numbers. If the second list does not contain the number, I want to return the value "no" in the cell to the right of the first number. Here's an example: A B C D List 1 List 2 1 1234 no 1235 2 1235 1237 3 1236 no 1238 4 1237 5 1238 6 1239 no |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return a value if item does not appear on list
In B1 enter the below formula and copy down as required
=IF(COUNTIF(D:D,A1),"","NO") If this post helps click Yes --------------- Jacob Skaria "Staceyglow" wrote: I'm sure there is a way to do this with VLOOKUP or a similar function, I just don't know how..... I want to compare two lists of numbers. If the second list does not contain the number, I want to return the value "no" in the cell to the right of the first number. Here's an example: A B C D List 1 List 2 1 1234 no 1235 2 1235 1237 3 1236 no 1238 4 1237 5 1238 6 1239 no |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return a value if item does not appear on list
Worked like a charm!! Thanks!
"Jacob Skaria" wrote: In B1 enter the below formula and copy down as required =IF(COUNTIF(D:D,A1),"","NO") If this post helps click Yes --------------- Jacob Skaria "Staceyglow" wrote: I'm sure there is a way to do this with VLOOKUP or a similar function, I just don't know how..... I want to compare two lists of numbers. If the second list does not contain the number, I want to return the value "no" in the cell to the right of the first number. Here's an example: A B C D List 1 List 2 1 1234 no 1235 2 1235 1237 3 1236 no 1238 4 1237 5 1238 6 1239 no |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to pair each item on one list to each item on another list | Excel Worksheet Functions | |||
| Select an item from dropdown list but return value from adjacent c | Excel Discussion (Misc queries) | |||
| How do I return a value by clicking an associated list box item | Excel Worksheet Functions | |||
| Match return #NA ...though item exists! | Excel Discussion (Misc queries) | |||
| Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions | |||
Linear Mode
