Two work sheets, A and B. Need info from one sheet to the other
 

I have two work sheets, A and B. Work sheet A is a Master sheet, it has in
it a Part Number column, along with Description and Price columns of 50,000
parts. The other sheet B is just part numbers, 900 parts, no description or
price column. How do I get matching part number descriptions and prices from
sheet A to sheet B? All numbers in both sheets are unique, and all numbers
are in ascending order. Data needs to stay in proper columns, not
concatenate. Thank you

Two work sheets, A and B. Need info from one sheet to the other
 

Assuming part numbers, descriptions, and prices are in columns A, B, and C
respectively, use these formulae on Sheet B for Description
=VLOOKUP(A2,B!A2:C50001,2,false)

and for Price
=VLOOKUP(A2,B!A2:C50001,3,false)

"Lakewoodsale" wrote:

I have two work sheets, A and B. Work sheet A is a Master sheet, it has in
it a Part Number column, along with Description and Price columns of 50,000
parts. The other sheet B is just part numbers, 900 parts, no description or
price column. How do I get matching part number descriptions and prices from
sheet A to sheet B? All numbers in both sheets are unique, and all numbers
are in ascending order. Data needs to stay in proper columns, not
concatenate. Thank you