bring in data from one worksheet to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. I am wondering if someone can help to pull the price (3rd column) on
worksheet B into worksheet A, based on the priceclass. I know that on the
worksheets below, the price classes do not match, but in the full list that I
have,
they do match up.

Any help is appreciated.

thank you,

Worksheet A:
item code price class Product Name
C06VETRAO1313MO C06V0B VETRO AZUL OCEANO MOSAIC 13X13
C06VETRAQ1313MO C06V0B VETRO AQUA MOSAIC 13X13
C06VETRAZ1313MO C06V0A VETRO AZZURRO MOSAIC 13X13
C06VETRBC1313MO C06V0B VETRO BIRCH MOSAIC 13X13
C06VETRBK1313MO C06V0C VETRO BLACK MOSAIC 13X13
C06VETRCA1313MO C06V0B VETRO CARMEL MOSAIC 13X13
C06VETRFO1313MO C06V0C VETRO FOREST MOSAIC 13X13


Worksheet B:
Price Class Product Name
Price
C06V0A VETRO 3/4 X 3/4 ON 12X12 MESH 3.6 SF
C06V0B VETRO 3/4 X 3/4 ON 12X12 MESH 3.6 SF
C06V0C VETRO 3/4 X 3/4 ON 12X12 MESH 4.5 SF
C06V0D VETRO BLD 3/4 X 3/4 12X12 MESH 4.5 SF
C07O0A OPALESQUE 1X1 ON 12X12 MESH 13.5 SF
C07O0B OPALESQUE 1X1 ON 12X12 MESH 13.5 SF
C07O0C OPALESQUE BLEND 1X1/12X12 MESH 13.5 SF
 
Try this:
Create a new Column 4 in Worksheet A and enter this formula (of course
changing the references to be correct):
=INDEX(WorksheetB!$A$1:$C$7,MATCH(B2,WorksheetB!$A$2:$A$7,),MATCH("PriceClass",WorksheetB!$A$1:$C$1,))
 
Back
Top