Find/Replace

[Jenina]

Hello Community,

I wanted to replace the details under Owner column based on the 'book' column from the lookup file (simple vlookup in excel). I just can't figure out the correct tools.

I want to retain the blanks/NA if possible as well.

I attached the sample files with output. Thank you!

[SPetrie · Accepted solution]

Use the Find/Replace tool to compare the Book columns and append the owner field from your lookup. Any book that doesnt match will be null and you can use a formula tool to change those however you want them to be displayed.

[Jenina]

@SPetrie  Thank you!