=lookup(1,0/find($a$2:$a$5,e2),$b$2:$b$5)
则返回"#n/a",这里的原理和上一条公式一样,给一个很大的数让 lookup
解析lookup的经典查找方式
method of assigning electronic shelf labels to price lookup file
数据分析丨excel丨函数xlookup
Tips:Do Not Provide
Personal Loans: Go Easy On Your Finances
Finance, Finance, Finance, Foreign Exchange, Stocks, Currency Circle, Venture Capital, Bitcoin, ICO...