Need help with a calculation that matches computer name & software

I need help with a calculation or formula that will match the computer name from one worksheet and put an "X" on a report in another worksheet for the software that computer name has on it. The script I am trying to work with was done by a previous user and I can't tell what it is referencing and I want the script to reference a separate workbook for the data. Can anyone help me with this? I am trying to sift through a 40,000 line machine print out with 1172 machines and I am trying to create a software report that shows all of the software for each machine. If that makes sense?

What I am trying to do is match the computer name from software Due Report Test worksheet with the name on the Computer Data Master List. If the name matches then mark with an "x" for all software that computer has listed on it in the Master list and put an "x" on the Report. Hopefully that makes sense. In the master list, there are several different software entries with the same computer name and I am trying to list what computer has what software on it in the Report. I tried the formula you posted and it is marking the X but it is marking the "X" in every column. If the software is not listed for that computer I want it to leave the cell blank.

The calculation/formula the previous user was using is =IF(IFERROR(INDEX($B:$B,MATCH($S4&AC$3,$B:$B&$C:$C,0)),"")="","","x") however, all of the data was on one sheet and my data list is too large for that so I need to be able to use a separate workbook for that.

Hey Jeffrey, I truly appreciate all the help with this. This is totally out of my wheelhouse. What is happening when I run that formula in the worksheet, it is putting an "X" in every cell. What I need it to do, is only put an "X" in the cell if the software listed matches for that computer name otherwise if that computer does not have the software on it, it will leave the cell blank. I may not be explaining this very well. In my master worksheet I have 43,000 rows and repeating computer names for a total of 1127 computers. With that being said, I am trying to mark with an "X" in the appropriate cell that matches the software on that computer so I can total how many software licenses I have over the 1127 computers. Hopefully I am not making this too complicated.

That looks pretty good Jeffrey! but how to I add more data to the master list and still get it to run? do I have to copy the fields or lock the fields? Sorry this really isn't in my wheelhouse. I don't normally do a lot of formula work in excel. I don't really care if it bogs the processor since that will be the only thing runny on that machine but if you think it will take forever to run do you have any ideas on how to do it differently. I will be using this method moving forward with a lot of projects i am working so so I would like to use this to do it since doing 1127 machines manually would make my eyes cross.

Sweet! I really appreciate all the help again! you are awesome! I will try it out on a smaller test batch and let you know as soon as I can. And thanks for the explanation! That really helped a lot!

I notice that the data in the sample file appears to be sorted by Computer Name (ascending), then by App Name (ascending). Would this be the case with your actual data?

If it is, then it might be possible to improve processing time by generating dynamic ranges for each computer name, then checking the app name with something on the basis of

Formula:

Please Login or Register  to view this content.

Where app_name is the range of apps in column C dynamically generated according to computer name in column B using something like

Formula:

Please Login or Register  to view this content.

as a named range definition. See attached copy of your file with this set up.

Let me take a look at that Jason and let you know.