I have been working on this spreadsheet for a while now and i cant seem to figure out a way to auto fill my cells with data from another spreadsheet. In columns A-C (A has item name, B has Type of item, C has the Style of the item) i have hard data that doesn't change and in column D (D has the Size of the item) i would like it to go into the spreadsheet and find the right value for the row, but the problem i'm having is that i have duplicate style's and i cant figure out a way to remove the Size from the list so that it does not get used again. If you need me to expand more on this please ask and i will do my best to explain better.