Table Merging
Table1 has part #s A01, A02, A06 and related pricing of $12.50, $1.23,
and $7.48. Table2 has part #s A02, A06, A10, A15 and pricing of $8.05, $2.03, $5.17, $6.20 How can I merge these two tables to wind up with a combined table that looks like this: Part # Price 1 Price 2 --------- ------------ ------------ A01 12.50 A02 1.23 8.05 A06 7.48 2.03 A10 5.17 A15 6.20 Thanks in advance! |
Table Merging
You can use a Vlookup formula
If the merged Table was in columns A1:C3 then in cell C3 put th following formula =vlookup(A1,$D$1:$E$100,2) adn copy down colun D1:E100 is the table with Price 2 where the part number is in Column D and the Price is in Column E. "jvbelg" wrote: Table1 has part #s A01, A02, A06 and related pricing of $12.50, $1.23, and $7.48. Table2 has part #s A02, A06, A10, A15 and pricing of $8.05, $2.03, $5.17, $6.20 How can I merge these two tables to wind up with a combined table that looks like this: Part # Price 1 Price 2 --------- ------------ ------------ A01 12.50 A02 1.23 8.05 A06 7.48 2.03 A10 5.17 A15 6.20 Thanks in advance! |
Table Merging
Joel,
The problem is not to put the prices in there - that would indeed nicely work with the vlookup as you mention. The challenge is to merge the part numbers. Cheers - Jan On Sep 17, 11:51*am, Joel wrote: You can use a Vlookup formula If the merged Table was in columns A1:C3 then in cell C3 put th following formula =vlookup(A1,$D$1:$E$100,2) adn copy down colun D1:E100 is the table with Price 2 where the part number is in Column D and the Price is in Column E. "jvbelg" wrote: Table1 has part #s A01, A02, A06 and related pricing of $12.50, $1.23, and $7.48. Table2 has part #s A02, A06, A10, A15 and pricing of $8.05, $2.03, $5.17, $6.20 How can I merge these two tables to wind up with a combined table that looks like this: Part # * * *Price 1 * * *Price 2 --------- * * ------------ * * ------------ A01 * * * * 12.50 A02 * * * * *1.23 * * * * *8.05 A06 * * * * *7.48 * * * * *2.03 A10 * * * * * * * * * * * * *5.17 A15 * * * * * * * * * * * * *6.20 Thanks in advance!- Hide quoted text - - Show quoted text - |
Table Merging
There are VBA way of doig this. If you want to avoid VBA you can get a
unique set of values using Data - Filter - Advance filter - Unique records. Copy the two sets of part number to a new section of the worksheet. Then use advance filter to get a unique list of part numbers. Now use Vlokup to fill inthe new table with prices from both original lists. "jvbelg" wrote: Joel, The problem is not to put the prices in there - that would indeed nicely work with the vlookup as you mention. The challenge is to merge the part numbers. Cheers - Jan On Sep 17, 11:51 am, Joel wrote: You can use a Vlookup formula If the merged Table was in columns A1:C3 then in cell C3 put th following formula =vlookup(A1,$D$1:$E$100,2) adn copy down colun D1:E100 is the table with Price 2 where the part number is in Column D and the Price is in Column E. "jvbelg" wrote: Table1 has part #s A01, A02, A06 and related pricing of $12.50, $1.23, and $7.48. Table2 has part #s A02, A06, A10, A15 and pricing of $8.05, $2.03, $5.17, $6.20 How can I merge these two tables to wind up with a combined table that looks like this: Part # Price 1 Price 2 --------- ------------ ------------ A01 12.50 A02 1.23 8.05 A06 7.48 2.03 A10 5.17 A15 6.20 Thanks in advance!- Hide quoted text - - Show quoted text - |
All times are GMT +1. The time now is 05:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com