Hi, I am facing this issue whereby in the default file, for the code column (B) the number is stored as text and I am unable to execute index & match. Can you please advise for a solution?

Hi Ned, Thank you for your response. The solution you proposed did not work with my version of Excel, even after pasting special values, there was still an error as the numbers were still stored as text. It only worked after I manually overwrite the "Trace Error" by converting the text format to number format.

Hello, Yes, a very easy solution is to Copy and Paste and use Paste Special Values to obtain numbers. Hope this helps! Best, Ned

Thanks for letting us know! This could be helpful to other students!

Follow this topic

Weiqiang Chung

Last answered:

07 Oct 2022

Posted on:

04 Oct 2022

Resolved: Issues with number stored as text

in Introduction to Excel / Using Index & Match as a Substitute for Vlookup

3 answers ( 1 marked as helpful)

Ned Krastev

Instructor

Posted on:

04 Oct 2022

Weiqiang Chung

Posted on:

07 Oct 2022

Helpful answer

Ned Krastev

Instructor

Posted on:

07 Oct 2022

Resolved: Issues with number stored as text

Submit an answer

related questions