Forum Discussion
othafa
Apr 24, 2019Copper Contributor
Vlookup to find multiple variations of a text string
Hi, first time post here so bear with me! I am trying to create a worksheet that displays a list of shift types with names of staff allocated that shift over the period of a week. I can do this ...
- Apr 24, 2019
othafa
Apr 24, 2019Copper Contributor
Thanks for this, it certainly does what I want.
Is there a way to convert sheet 1 into the table (A1:C24) you created in Tabelle1. I ask because the format of sheet1 is fixed as it is?
Thanks.
Detlef_Lewin
Apr 24, 2019Silver Contributor
That is the PQ part. Goto to the PQ editor to see the queries and steps.
To load the table into PQ I assigned a name to the table range (-> name manager),