Hi,

Trying to combine 2 sheets from separate workbooks, and match the information on both of them. Context:

Book1 has IP address (and other relevant information) from XXX.XXX.XX.11 to XXX.XXX.XX.61
Book2 has IP address XXX.XXX.XX.01 to XXX.XXX.XX.252

I want to match the IP addresses, then have the info from Book2 go into Book1. I've managed to do this with Power query. However, it messes up my IP address order because Book 1 starts at .11 and Book 2 starts at .01. The 'sort and filter' doesn't work because it can't tell the difference between 0.19 and .190. How do I fix this? I can't figure it out. THanks.