我正在尝试根据关键字在一行中查找一个值并返回该值。 例子:
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
有没有办法使用 Excel 函数(VLOOKUP、HLOOKUP、INDEX、MATCH 等)来存档它?