Forum Discussion
Partial text match and display in a separate worksheet
https://www.microsoft.com/en-us/download/details.aspx?id=15011
Hi ,JMB17
Thanks for that. I did quite a bit of reading prior to posting around the 'limitations' of vlookup text strings and the need to potentially use the fuzzy match. I would've thought that there was another way to simply find and display the text from one worksheet to another. For example, the projects all have the BBR prefix - I thought it was possible to find and display any text containing 'BBR' to display in the comparison worksheet that I've created?
Cheers
- Re-reviewing your first post, you mentioned a third worksheet that you are matching to these two (and not matching these two to each other)?
If the third worksheet has a keyword phrase that will definitely be contained within the other two worksheets, then you could use Index/Match to perform the lookup using wildcards.
=Index(RangeToReturn, Match("*"&keyword&"*", RangeWithDescriptions, 0))Sorry - My explanation wasn't clear. I have 3 data sources (1 from Primavera P6 and 2 excel files) - all contain the same projects with differing estimated project $ values as well as the detailed data of how the estimates are built up. My task is to compare the three estimated $ values and understand where they vary. The project nomenclature varies across the three data sources but the product name prefix is consistent i.e. BBR as is the kilometre start and finish markers - so those are the unique identifiers. The first task is to display the project names from the three data sources on a separate worksheet, firstly to confirm that the numbers of projects match (scope can be removed/changed at short notice and it isn't communicated well to the owners of the three data sources).
Hope that make more sense.