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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Eliminating Duplicate Data
- Thread starter jrummel
- Start date
cornflakegirl
Well-known Member
- Joined
- Nov 4, 2004
- Messages
- 2,023
Welcome to the board.
You could use advanced filter or a pivot table to generate a unique list of customers.
Alternatively, assuming your customer numbers start in A1, try this formula:
=VLOOKUP(A1,LookupRange,2,FALSE)*(COUNTIF($A$1:A1,A1)=1)
This will only pull the vlookup value for the first instance of the customer value.
You could use advanced filter or a pivot table to generate a unique list of customers.
Alternatively, assuming your customer numbers start in A1, try this formula:
=VLOOKUP(A1,LookupRange,2,FALSE)*(COUNTIF($A$1:A1,A1)=1)
This will only pull the vlookup value for the first instance of the customer value.
Upvote
0
Similar threads
- Question
- Question
