2 Sheets , populating price column from 1 sheet to another ?

[jezrp22]

Hi ,

I'm a noob so bear with me

Ok , the situation is the following :

1/ I have 2 sheets of data that contain product information (price and code)

2/ "Sheet A" is the master sheet that details all my products and codes , "Sheet B" contains the product codes and prices only

3/ The issue i have is that Sheet B does not contain all the product codes so i cant sort by product code then just copy and paste the prices

4/ I need to somehow get the "price" cell in Sheet A to look at Sheet B , look for the product code then populate the price cell with the corresponding price

i've been trying to use a COUNTIF function but it doesnt work ??

[Special-K]

Try
in SheetB!B1
=VLOOKUP(SheetB!A1,SheetA!A$1:B$100,2,0)
and copy down

where SheetB!A1 is the product code you want to find the price of.

[jezrp22]

Hi SPecial K , thanks for helping , but it doesnt seem to work , ive attached the sheet example.xlsx, i thinkk i can do it one sheet.

colum A is the price column b is the code , now i want colum f to be popualted with the correct price for the code ?

thank you so much , appreciated !!

[Glenn Kennedy]

Use this, in F2, copied down as needed.

Please Login or Register  to view this content.

[jezrp22]

perfct , amazin , big thanks !!

[Glenn Kennedy]

If that's it, can you mark the thread as solved and (preferably) say thanks to those who helped by clicking the Add Reputation button at the foot of their posts(s)?