Hi,

I have 2 sheets in a work book. One sheet contains the master list and the other Sheet is the Data Entry sheet.
However I need to look at 2 colums to populate the item description.
Stocktake.xlsx. I have attached the sample file for reference.
There are 2 input fields - IniqueItemCode and EAN
After input the item description should appear. There are cases where we have both values in Col A and Col B
and the Item description will Populate. Please advsie