Dear Sir/Madam,

Kindly let you know how to put vlookup formulas in excel sheet as per our requirements, requirements like number maching & last 2 or 3 Alph remove purpose required exact formulas,

Please resolve/revert asap,

thanks & regards,

Parameshwara Reddy

9740028353 

• Edited by parameshwara reddy Friday, July 31, 2015 7:29 AM type

Hi Parameshwara Reddy,

Based on your description, I can't confirm your requirements.

Did you want to return the last 2 & 3 digits or you want to delete the extra digits by using Vlookup formula?

Please be a bit more precise to explain your requirement so that I can get more accurate solutions to this problem.

If possible, you can create a sample file and send the sample file to our email address:
ibsofc@microsoft.com
Please Note: Please add the URL of the case in the email subject or body.

Im glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su