ExcelBanter - Appending Tables

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Appending Tables (https://www.excelbanter.com/excel-programming/313950-appending-tables.html)

RedLion

Appending Tables

Hi everyone!
I have two tables:
1. ProductCode; Price
2. ProductCode; Quantity
The first one is a full list of all available Products
and second is a list of Products are requested by
Customer!
So, I need to add a "Price" column to second table that
match the ProductCode from the first table.

Thank You in advance!

Michael Hachen

Appending Tables

Try VLOOKUP

Mike
"RedLion" schrieb im Newsbeitrag
...
Hi everyone!
I have two tables:
1. ProductCode; Price
2. ProductCode; Quantity
The first one is a full list of all available Products
and second is a list of Products are requested by
Customer!
So, I need to add a "Price" column to second table that
match the ProductCode from the first table.

Thank You in advance!

All times are GMT +1. The time now is 02:20 AM.