This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Is it possible to always take a reference "cell" that contains a title such as HELLO and then select further cells based on this?
So in the above case, always find hello and then 2 down and 3 across?
Hope this makes sense
I think we'll need a little more information about the use case and perhaps some sample data to give a good answer.
At first glance, perhaps joining on record ids would be a first approach. I.e. record Id tool, add 2 to record Id and join to original data and then extract the appropriate column's data.
This was a nice challenge to round off my day!
I've attached an example workflow which i've documented to provide you guidance on how it works.