Hello, I was trying to use the Vlookup function to create a new table with information from a certain row. What I planned was to create a dialogue box and input a specific reference number (5-digit integer), then search for the said reference number in the excel and copy the information in the corresponding row to a new sheet.
However, when I typed a reference number into the dialogue box after hitting run, it seemed like the application cannot identify what I typed as numeric, and they failed to locate the correct cell and output the information next to the correct cell to the designated place. Is there any way that I can define the property of the value which I enter into the dialogue box to numeric? Thanks!