| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Matching a sampling # to it's row #number
here is my data:
col A col B col C col D store# row sampling # 3 1 210 5 2 5 7 3 11 10 4 510 12 5 X 42 I want to be able to make an "X" in column C if the row # in column B is also located in column D in the case of store # 12 above, otherwise have the cell in C remain blank. thank you in advance! jane |
|
#2
|
|||
|
|||
|
In C2 place the formula
=IF(ISNA(VLOOKUP(B2,$D$2:$D$100,1,0)),"","X") and copy down. Hope this helps Rowan "Jane" wrote: here is my data: col A col B col C col D store# row sampling # 3 1 210 5 2 5 7 3 11 10 4 510 12 5 X 42 I want to be able to make an "X" in column C if the row # in column B is also located in column D in the case of store # 12 above, otherwise have the cell in C remain blank. thank you in advance! jane |
|
#3
|
|||
|
|||
|
you are a life saver :)
it worked perfectly - thank you! "Rowan" wrote: In C2 place the formula =IF(ISNA(VLOOKUP(B2,$D$2:$D$100,1,0)),"","X") and copy down. Hope this helps Rowan "Jane" wrote: here is my data: col A col B col C col D store# row sampling # 3 1 210 5 2 5 7 3 11 10 4 510 12 5 X 42 I want to be able to make an "X" in column C if the row # in column B is also located in column D in the case of store # 12 above, otherwise have the cell in C remain blank. thank you in advance! jane |
|
#4
|
|||
|
|||
|
You're welcome!
"Jane" wrote: you are a life saver :) it worked perfectly - thank you! "Rowan" wrote: In C2 place the formula =IF(ISNA(VLOOKUP(B2,$D$2:$D$100,1,0)),"","X") and copy down. Hope this helps Rowan "Jane" wrote: here is my data: col A col B col C col D store# row sampling # 3 1 210 5 2 5 7 3 11 10 4 510 12 5 X 42 I want to be able to make an "X" in column C if the row # in column B is also located in column D in the case of store # 12 above, otherwise have the cell in C remain blank. thank you in advance! jane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| doubling a number X number of times | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| Matching data in columns | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
