Thanks:  0
Likes:  0

# Thread: not for the weak

1. I have a list of part numbers in column A and a price in column B. What I need to do is grab the dup numbers in A and put it's price in column C next to the first occurance of that number. Could also have two columns of part numbers and two columns of prices. Just need to get both prices of the dups into one row.

thanks

2. On 2002-03-07 07:43, mrxwannabe wrote:
I have a list of part numbers in column A and a price in column B. What I need to do is grab the dup numbers in A and put it's price in column C next to the first occurance of that number. Could also have two columns of part numbers and two columns of prices. Just need to get both prices of the dups into one row.

thanks
Assuming you only have one duplicate number in column A (i.e., part number 1234 will show up a maximum of two times), you could put this formula in C1 and copy down to C400 (assumes your data goes from A1:B400, make changes as required):

=IF(ISNA(VLOOKUP(A1,A2:\$B\$400,2,0)),"",VLOOKUP(A1,A2:\$B\$400,2,0))

For the situation where you have two columns of part numbers and prices, which columns are they located?

Regards,

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•