View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Search for a value that repeats several times in another table

Hi,

I did not mention that you can't build the entire table off of the first
column using VLOOKUP because there are repeat entries.

As a side - when you say you used a formula and it didn't work, it's often
best to show us the formula.

--
Thanks,
Shane Devenshire


"RobertoB" wrote:

Hi, i have a table that looks as follows:

CUSTID CUSTNAME ADDRESS
123 customer1 The street
345 customer2 The road


And I have another table that looks as follows

CUSTID PRODUCT VOLUME
123 z-Units 13
123 a-units 25
345 z-units 10
345 b-units 5
123 b-units 12


And I need and output table that loos as follows:

CUSTID CUSTNAME ADDRESS PRODUCT VOLUME
123 customer1 The street z-units 13
123 customer1 The street a-units 25
123 customer1 The street b-units 12
345 customer2 The road z-units 10
345 customer2 The road b-units 5


I have try to do this with VLOOKUP, and also with a combination of OFFSET
and MATCH, but I always get an N/A. As tbale 1 and table 2 can have variable
lenghts, I wonder what can I do.