Forum Discussion
Vlookup to find multiple variations of a text string
A formula solution. The key element is to perform a wildcard search for anything that contains a shift name, e.g. search for "*LMP*". There is a catch that the abbreviations for Early and Late are to be found within other shift codes so I converted them to "E0" and "L0" to avoid 'false positives'.
= IFERROR( INDEX( Name, MATCH( shift, INDEX(shiftTable, 0, day), 0 ) ), "" )
The names 'day' and 'shift' are relative references and the innermost INDEX returns the 3 rows for a given day of the table.
As for your other line of exploration, Power Query is available as an Office 2010 add-in free of charge from Microsoft. Your IT department could install it for you and I would recommend that they evaluate it themselves!
For me, what the documentation suggests and what actually happened were not the same thing. Power Query and Power Pivot both installed despite my not having the correct version of Office.
Now I am using Office 365 insider but that is because I was desperate to evaluate modern Dynamic Arrays (they are superb and now provide the basis of everything I do outside Power Query).
PeterBartholomew1 wrote:
For me, what the documentation suggests and what actually happened were not the same thing. Power Query and Power Pivot both installed despite my not having the correct version of Office.
Now I am using Office 365 insider but that is because I was desperate to evaluate modern Dynamic Arrays (they are superb and now provide the basis of everything I do outside Power Query).
Hi Peter,
Yes, I agree with both.
Documentation could be outdated. That was with "Where is Power Pivot" when expanding of Power Pivot on all SKU was announced first on uservoice, and doc was updated only in a while. Sometimes delay could be quite significant. However, I don't think there were some changes for outdated 2010.
Power Query becomes less important if you work within one notebook. My main scenarios of usage is to pick-up and transform data from different sources (SQL databases, files on SPO and like) to combine in one workbook with its local data. That was I did with Pivot Table connectors long ago, now PQ is the main tool.