Extract a certain value from table

[dreldrel]

Hi all, I'm struggling at extracting a specific value from a table. For example, I'd like to take the value "Amy" below the cell "name". The values are always below the cell "name".

Does anyone have an idea to sort it out? Thanks in advance

1	2	3
irrelevant cell	irrelevant cell	irrelevant cell
irrelevant cell	name	irrelevant cell
irrelevant cell	Amy	irrelevant cell

[Felipe_Ribeir0]

Hi @dreldrel 

One way of doing this

[dreldrel]

Hi @Felipe_Ribeir0,

Many thanks for quickly getting back to me. I was wondering what if the table length is dynamic and the name position is not fixed, is it possible to find the value as well?

[Felipe_Ribeir0]

Hi @dreldrel 

Could you please share some example table of how the position can be?

[dreldrel]

Hi @Felipe_Ribeir0 

No problem, it could be the below scenarios. The thing is that I'd like to output "Amy" to users no matter where is it in the table. Many thanks for your assistance.

1	2	3	4
irrelevant cell	irrelevant cell	irrelevant cell	irrelevant cell
irrelevant cell	irrelevant cell	irrelevant cell	irrelevant cell
irrelevant cell	irrelevant cell	irrelevant cell	name
irrelevant cell	irrelevant cell	irrelevant cell	Amy

or

1	2
irrelevant cell	irrelevant cell
name	irrelevant cell
Amy	irrelevant cell
irrelevant cell	irrelevant cell

[Felipe_Ribeir0 · Accepted solution]

Hi @dreldrel 

Read all possible columns and compare different rows at the same time can be tricky, here is one way of doing this using a batch macro, please see if it works for you:

Input 1

Input 2

Input 3

[OllieClarke · Accepted solution]

Hi @dreldrel 

here's a macro-less approach that outputs into a new column called 'OUTPUT' the value immediately below name

Hope that helps,

Ollie

[dreldrel]

Hi all, very appreciate for helping me figure out the solutions! Both are working.