Automatic Cell Entry from One Column to Another

[LabraLime]

Hello!
I have a list of 41 different document numbers that get entered into a larger set. I'm trying to see how I can create a formula that will automatically enter an "x" into a specific column if any of the 41 are triggered in a separate column. Any suggestions?

For example:
I have a list of document numbers that need to be checked with an "x" (for this ex: 123, 134, 333)-I want the "x" to automatically populate into a separate column so that the whole sheet can be easily filtered by that "x" column.

Doc #	other unrelated data	Need to be checked [x]
123​	aaa	x
122​	aaa
134​	aaa	x
333​	aaa	x

 

[JackDanIce]

Where is the list of document numbers that need to be checked against?

 

[LabraLime]

Where is the list of document numbers that need to be checked against?

Doc ID
002
003
022
031
141
192
196
330
332
338
340
350
400
420
431
432
441
449
450
452
453
461
470
477
482
485
509
603
610
612
614
615
620
624
627
671
675
709
782
858
999

 

[Joe4]

Where is the list of document numbers that should be checked with an "X" (what range are the stored in)?
Where is the list that it is to be compared again (again, what exact range)?

 

[LabraLime]

The list of Document Numbers are in the reply above, and the example is attached below.
Essentially I need an "x" to appear in Column B when one of the Document numbers from the list above are entered into Column H.
Right now, I'm having to periodically open the document and filter column H manually by each of the numbers individually and manually enter an "x" in Column B.

 

[Joe4]

The list of Document Numbers are in the reply above, and the example is attached below.

Well, that wouldn't do much good to your project, as your wokbook cannot look up this list in MrExcel!

In order to do this, your workbook is going to need to have access to this list of values.
I am just asking you where is it going to be stored, so we know how to write the formula to look these values up and do what you want.
Is it going to be on another sheet?
Is it going to be in another workbook?
What sheet/range will these values be stored in?

 

[JackDanIce]

@LabraLime imagine anyone reading this board cannot see what you can see what you can. Is the level of detail you're giving enough to solve?

I can't understand where your data is or how your spreadsheet is built, however, one solution I would try is using MATCH, IF and ISNUMBER as a formula in the output column.

I searched online for "Excel match value against a list" and this was the first result:

How to check if a cell value match to a list in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com

Which is similar to how I'd construct 'a' solution to a problem like this.

 

[LabraLime]

Well, that wouldn't do much good to your project, as your wokbook cannot look up this list in MrExcel!

In order to do this, your workbook is going to need to have access to this list of values.
I am just asking you where is it going to be stored, so we know how to write the formula to look these values up and do what you want.
Is it going to be on another sheet?
Is it going to be in another workbook?
What sheet/range will these values be stored in?

I can store the list in the same workbook on another sheet, if that would be the best option.
Just trying to determine the best course of action to avoid manually searching and checking this list for all of my future projects

 

[Joe4]

OK. Here is one way.
Put your list of numbers anywhere, on another sheet, or the same sheet (it does not matter), and then name that list "MyList", using Named Ranges.

Then, we can simply check to see if any value appears in that list, and return an "X" if it does.
If you have a value in cell A4, here is the formula you would use:

=IF(COUNTIF(MyList,A4)>0,"X","")

 

[LabraLime]

OK. Here is one way.
Put your list of numbers anywhere, on another sheet, or the same sheet (it does not matter), and then name that list "MyList", using Named Ranges.

Then, we can simply check to see if any value appears in that list, and return an "X" if it does.
If you have a value in cell A4, here is the formula you would use:

=IF(COUNTIF(MyList,A4)>0,"X","")

This works perfectly! Thank you so much for your help!