Vlookup based on column number

[pranee_007]

Hi Team,

I want to add a new column as shown in S1 below based on below conditions:

1. The Value in code needs to be searched only in the column number corresponding to that value in S2 and return the same value if found else 'Not found'.

2. The Value needs to be searched only in that particular column and not the entire data in S2.

For Example say the code is j2 and column number corresponding to that is 6, So it has to search for the value j2 in column 6 of S2 and return j2 if found.

S1:Already in Alteryx workflow -Main source
Code	Column Number	New Column
p2	1	p2
a3	8	a3
r4	3	r4
h6	9	h6
t8	4	Not found
j2	6	j2
m2	2	Not found
v7	7	v7
x8	5	Not found

S2: Outside - Needed to be loaded into Alteryx
LOS	HYU	JDI	FDD	DE	GRE	HYT	VSS	VBH
p9	m3	r1	t1	x2	j2	v3	a1	h1
p10	m4	r2	t4	x3	j3	v4	a2	h2
p11	m5	r3	t5	x4	j4	v5	a3	h3
p12	m6	r4	t6	x5	j5	v2	a4	h4
p7	m1	r5	t7	x6	j6	v1	a5	h5
p2	m9	r6	t2	x7	j7	v6	a6	h6
p1	m8	r7	t3	x1	j8	v7	a7	h7

[Jonathan-Sherman · Accepted solution]

Hi @pranee_007,

Is this what you're looking to achieve?

If this solves your issue please mark the answer as correct, if not let me know. I've attached my workflow for you to download if needed.

Regards,

Jonathan