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
=IF($B$2<>"",VLOOKUP($B$2,Main,8,FALSE),"error")
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.
Bookmarks