Forum Discussion
IP Address Training Template
I addressed the issue I had with the original post by creating tables and using XLOOKUP. By doing so, I made some progress.
The attached is the modified version of the original file. I'm putting notes at the bottom of the sheet so I can keep up with my issues for reference.
Insight/assistance appreciated and respected.
- TapsterJun 02, 2020Copper Contributor
The attached spreadsheet is doing what I intended when I started this post with one last thing I cannot figure out. It may not be possible without writing code but I wanted to ask and see if anyone had thoughts/advice. If one looks at the file one will see "Magic Number" pointing to J5. I am trying to figure out how to get that pointer to slide down between bits 23 and 2 based on the value in B4.
Advice/insight would be appreciated.
TAPS