Finding text in a data table and display results

Hello All,
I thought this would be easy but it has turned out to be a challange.

I have a search type of function where a user inputs a value in cell b2 and a vlookup table that returns the results in cell F2

input Cell B2 = x.x.x.x
Result Cell F2 = Device Name

Please Login or Register  to view this content.

this part is working fine but I want to then take the device name from this result and do another look up becuase the device name could be listed in the table 35+ times.

I have attached a sample.xlsx sheet because I don't think this is easy to explain in comments. Sample.xlsx
The sample may clear it up. Thanks in advance to all who take a look.

Hi Bernie,
works like a charm in the sample sheet you provided. When I transfer the formula in H4 to my production sheet it doesn't return the row number? If I remove the formula and input the row number all the other fields come back with the correct info? do I need to re-define the range on the data table sheet or something?

oh sorry, didn't do the ctrl shft ent when I moved it to the production sheet. It's working now. Thank you so much for your time!