Hello,
I feel like this is probably one of those things that really simple and probably staring me in the face, but I'm just not catching onto it.
We have a spreadsheet which contains an IP column. This column could contain anything from 1+ IP address, column delimited, for each IP that the row applies to. We have another sheet which has a list of each individual IP, and their corresponding hostname, with one matching IP and host for each row. I'm trying to work out how to take the comma delimited IPs, match each one against individual IPs from the second sheet, and then add the corresponding hostnames, also comma delimited, into the hostname column. So, in essence, take multiple values from Sheet1:ColumnA, match against individual values in Sheet2:ColumnA and input the values from Sheet2:ColumnB to Sheet1:ColumnB.
Hopefully the two tables above demonstrate how the data is shown. I've included an example of what a complete one would look like in the first row on sheet 1.
I feel like this is probably one of those things that really simple and probably staring me in the face, but I'm just not catching onto it.
We have a spreadsheet which contains an IP column. This column could contain anything from 1+ IP address, column delimited, for each IP that the row applies to. We have another sheet which has a list of each individual IP, and their corresponding hostname, with one matching IP and host for each row. I'm trying to work out how to take the comma delimited IPs, match each one against individual IPs from the second sheet, and then add the corresponding hostnames, also comma delimited, into the hostname column. So, in essence, take multiple values from Sheet1:ColumnA, match against individual values in Sheet2:ColumnA and input the values from Sheet2:ColumnB to Sheet1:ColumnB.
Book1 | |||
---|---|---|---|
B | |||
3 | |||
Results |
Book1 | |||
---|---|---|---|
B | |||
7 | |||
Hosts |
Hopefully the two tables above demonstrate how the data is shown. I've included an example of what a complete one would look like in the first row on sheet 1.