I have a list of customer data and for some customers there are multiple records or rows of data. I am using the customer numbers from this list to vlookup cost data from another spreadsheet. Of course, when I do the vlookup, the cost data value is returned for every row that the customer number is repeated on the original list. Does anyone know how to pull the data in a vlookup formula only once? I've tried embedded formulas and can't seem to get the right one to do the job.