Thanks in advance for your time.
I am trying to figure out a formula to help me return data fields that match information in columns. Basically I have two columns that contain not exact matches (ex: (last four digits of host name and first four digits of serial number) and each Hostname has a corresponding IP address. I am trying to find the corresponding IP address of all hostnames that match serial numbers in a large array of data. You see below the last four digits of the host name match the first four of the serial numbers, so I would like to write a formula that can produce the corresponding IP address for these hostnames. I hope I’m explaining this correctly.
What I have done so far was use right and left formulas to produce the digits, then an if statement to see if they match each other. Then I’m trying to write an index/match to produce the serial number, but I can’t get it to work. I’m feeling that there might be an easier way to do this.
Thanks so much for your help.
By: Luke McConaghyy