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

Extract Asset Number from Description

Hello All,

Attached is the excel which has Description of Expenses in sheet 1 named Expenses and Vehicle Nos. in sheet 2 named Vehicles. I need to extract vehicle nos. from the description whichever are matching with Vehicles list in 2nd sheet. In addition, need to identify expense type based on the expense type categorized. Later on, will add few more expense types too. Need your help in resolving this please.

Thank You and Regards,
Pavan.
 

Attachments

  • Query 1.xlsx
    15.2 KB · Views: 18
Back
Top