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

Find value with certain caracters based on condition

jonastiger

Member
Hi
Here is Table 1 with data. In column "Cod" I have values that begin by "TS*" or "KW*"
61176

In Table 2 I need to place only "KS*" values that match "Ref" values.
61177

how to apply this through Index/Match or Vlookup?

Thank you in advance
JT
 

vletm

Excel Ninja
jonastiger
1) "KS*"-values from Table1 to Table2 ...
... but ... how many "KS*"-values can You see?
2) with a sample Excel-file, something else could be possible to do.
 

AlanSidman

Active Member
An alternative option is use Power Query. Any additions to the tables would automatically be updated in the result when "Refresh" Icon is clicked. Look at this file. This is available to you if you have Excel 2010 or later.
 

Attachments

Top