How To Vlookup Numbers Stored As Text In Excel?
2. If your lookup value is number format, and the ID number in the original table is stored as text, the above formula will not work, you should apply this formula: =VLOOKUP(TEXT(G1,0),A2:D15,2,FALSE) to get the correct result as you need.
沒有留言:
張貼留言
注意：只有此網誌的成員可以留言。