Good day!
i have raw data which has fieldname 'hscodes' in worksht_1. in worksht_2 i have list of codes (hscodes, 10digit codes) indicating its respective pvoc (X for exempted, Y for subjected). I wanted to match the hscodes in worksht_1 and create a new fieldname = 'PVOC' and put X or Y depending on its HScode with reference to hscodes in worksht_2.
thanks and have a great day!
Bookmarks