Forum Discussion
Match data in 2 columns and give value from 3rd column
Hello, I have a pricing spreadsheet from our supplier, which gives their part numbers in column A. But many parts are available in different colours, so they have used a "Colour Code" entry in colum...
Thanks very much OliverScheurich and Riny_van_Eekelen - I ran into trouble because there were also duplicate entries, so their prices were being added together to give the price. But I've worked out how to remove them and now it works 😄 Appreciate your time!