I want to find out the period from this excel If its period P08 then I have to find out the location forUnique ID col that is BX3 Dynamically...Similarly for all the periods P9,P10

image

Hi @aparna30 ,

Could you explain us a bit more of your requirement ?

The details provided will not help us much in understanding what are the Inputs, what might possibly be the logic to use (Or How you do it manually) and what should be it’s expected output.