If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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
|
|||
|
|||
Return a value if item does not appear on list
In B1 enter the below formula and copy down as required
=IF(COUNTIF(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
|
|||
|
|||
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,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 |
Thread Tools | |
Display Modes | |
|
|