• 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.

Vlookup number stored as percentage

ashish mehra

Active Member
Hi

I import data & format of my range contains combination of number, text, percentage.

Is there any way we can return the result with same format?
 
Are the different data types in separate columns ?

If not, you can setup 3 helper columns tom extract each set of data

Can you attach a sample of 20-30 rows of data?
 
Back
Top