I've tried following the MS Online documentation but no luck.

I want to setup data validation with the validation data residing in a
different workbook. Any help will be appreciated.