Find/Replace

Question

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!

Table.xlsx

lookup.xlsx

SPetrie · Accepted Answer

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.