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!
Solved! Go to 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.
@SPetrie Thank you!