View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lakewoodsale Lakewoodsale is offline
external usenet poster
 
Posts: 7
Default 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