Vlook up option

[rojan]

Hi,

I need a help to resolve VLOOKUP option for below file

sheet 1	account no
ABC	1
CBA	2
ZUZ	5

sheet 2
ABC	200
CBA	500
ZUZ	600

I want to get account no from sheet 1 and put it in sheet 2 based on name.

[brandon_bunney]

Attached is a workflow with a join that takes account no from sheet 1 on the first text input and joins to sheet 2 on the 2nd text input.

[vizAlter]

Hi @rojan — Try this solution using a "Find Replace" tool: