I'm trying to lookup a value in a row based on a keyword and return the value. Example:
Column 1 Column 2 Column 3 Result
http://1stexample.com http://2ndexample.com http://3rdexample.com =LOOPUP for "1stexample" should return http://1stexample.com
http://1stexample2.com http://2ndexample2.com http://3rdexample2.com =LOOPUP for "1stexample" should return http://1stexample2.com
Any way to archive this with an Excel functions (VLOOKUP, HLOOKUP, INDEX, MATCH, etc)?