Forum Discussion
IT vs Facilites data
Hello all. I have a list of IP ranges, site codes, and subnets. I need to cross reference those with a facilities list that contains friendly names, addresses, etc. The only common reference I have ...
Thanks!
I had to make some alterations as my spreadsheet is a table. Once I converted to range, it worked.
The drawback is, the source sheet has repeated listings for multiple site codes. In this case, the result of the formula is "#SPILL!". Is there any way around that?
Nate
The best alternative should be Power Query however. In the attached file you can enter data into the blue dynamic tables. Then click in any cell of the green table and right-click with the mouse. Then select refresh.
OliverScheurich it works, thank you!