We have a dump from our Orion SolarWinds in a sheet called "ITS Master". The "ITS Master" needs to identify if the "IPAddress" already exists and identify those that do not. The column name "IPAddress" exists in every sheet but the placement of "IPAddress" changes by spreadsheet since not all values for this device are the same.
I have used "Matches with Master" and "No Match with Master" in the other sheets against the Master List. I am just having problems getting the Master List to match each individual sheet in the Workbook. If possible, can we identify how many times that the IP address is listed in the Master List.
I modified the spreadsheet with just a subset of this information to make it easier to manage. I removed a lot of unnecessary sheets, columns, and rows that are not essential.