import a value from another table according to a same cell ID

[xelan]

Hello

I have two excel tables one is for "products" and one is "product
quantity".

"Products" table has the following columns

A:Indicator
B:Manufactureur
C:Man Code
D:SKU
E:description 1
F:etc

"Products quantity" has the following columns
A: SKU
B: Quantity

The products SKU are located on different rows in both tables, an
"products quantity" contains the quantity of every product that I'
like to add to a new column in "products".

How could I import the values of Quantity in "products quantity" int
products according to each products SKU. Would consolidate be th
answer and how to use the feature for that? Or is there any other wa
to do that.

Thanks for the help and if more clarification is needed please let m
know

 

[jeff]

Hi,

Use the Vlookup function in your new quantity column -

you'll use the SKU in your products to do a lookup
in your products quantity table, and return the quanity.

See Help: VLookup

jeff

 

[xelan]

Thanks Jeff it's what I was looking for and it works