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

  • Thread starter Thread starter Lakewoodsale
  • Start date Start date
L

Lakewoodsale

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
 
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)
 
Back
Top