Find and replace not working

[Amy123]

Hi Team,

Can anyone help me how to perform the vlookup on alteryx for attached text file.

I need Status column in Find sheet .

Thanks

[atcodedog05]

Hi @Amy123 

Here is how you can do it.

Workflow:

Hope this helps : )