• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Expected data is not getting extract from Sheet1 to sheet2

J

Jagdev Singh

Active Member
Hi Experts,

I am not sure why I am not getting the data from sample1 to Sample2 sheet. I am applying Vlook formulae but it is extracting very few data instead of the extected result.

Regards,
JD
 

Attachments

Hi All

I am somehow able to fix this issue. The issue was sith the data in Sample2.xlsx file. The number were placed as text and that was causing the issue. I followed the below steps to convert the text number into number.

  1. Select one column of cells that contain the text.
  2. On the Data menu or ribbon, click Text to Columns.
  3. Under Original data type, click Delimited, and click Next.
  4. Under Delimiters, click to select the Tab check box, and click Next.
  5. Under Column data format, click General.
  6. Click Advanced and make any appropriate settings for the Decimal separator and Thousands separator. Click OK.
  7. Click Finish.
Once this is done the expected result gets extracted from the Sample1 into Sample2. Thought to share with you as well.

Regards,
JD
 
You must log in or register to reply here.
Back
Top