OK, solved it now and thanks to Froli for the heads up on a simpler way of getting the IP stem. The full formula - not for the faint hearted
- to do this in a single cell is
=INDEX('Library IP Addresses'!$A$1:$B$200,MATCH(LEFT(SUBSTITUTE(T2,". ","^",3),FIND("^",SUBSTITUTE(T2,".","^",3))-1),'Library IP Addresses'!$A$1:$A$200,0),2)
where T2 is the cell containing the full IP address.
This then gives a #N/A if an exact match is not found.
STOP: As I posted so did frolicols with what looks like a simpler solution - I'll try that too.
Rob
Bookmarks