One way is to use VLOOKUP

Assuming the tables in sheets A & B
are in cols A to C, data from row2 down

In sheet: A
-----------
Paste the lables into D1:E1 : PartName, UnitPrice

Put in D2:
=VLOOKUP($A2,B!$A:$C,COLUMNS($A$1:A1)+1,0)

Copy D2 across to E2, fill down as far as required
Format col E as currency

The above will bring over the PartName & UnitPrice
data from sheet B's cols B and C into sheet A's cols D and E
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"vitality" <vitality.1vdtqf_1126757149.3353@excelforum-nospam.com> wrote in
message news:vitality.1vdtqf_1126757149.3353@excelforum-nospam.com...
>
> hi all!
>
> Can anyone help to solve the follow problem:
>
> Spreadsheet A has the follow column:
> -PartNo
> -VendorCode
> -Quantity
>
> Spreadsheet B has
> -PartNo
> -PartName
> -Unit Price
>
> PartNo in both table are related and unique.
> There are thousand of data in each spreadsheet. It is impossible to use
> the if statement to join two tables, Also.. I understand it can use
> Access to do it very easily, but I do not want to use Access... can I
> do it in Excel?
> Pls help...
>
> How can I join these two tables into one table, has all those
> information, as:
> New spreadsheet
> -PartNo
> -VendorCode
> -Quantity
> -PartName
> -Unit Price
>
> Thank you very much for any suggestion.
>
>
> --
> vitality
> ------------------------------------------------------------------------
> vitality's Profile:
http://www.excelforum.com/member.php...o&userid=27267
> View this thread: http://www.excelforum.com/showthread...hreadid=467742
>