So if I choose 101857 in a cell in Column "c" then the corresponding column in D should be automatically filled in with value Sales.eg: If i choose 101857 in cell C3 then D3 should be auto populated with sales
I want this to be applied in all the cells in C and D columns.Please help!!!