Then use..........
=VLOOKUP(A2,'C:\[Pricing.xls]Sheet1'!A:C,3,FALSE)*B2

A:C means for Excel to look up A2 in the Range of column A to column C,
(actually only lookup in column A, but capturing columns B and C for data
retrieval).........this can be limited if you wish to something like
A1:C100, ...............the "3", means that when Excel finds a matching
Value in column A, to step over to the right 3 columns and return the value
in that cell...............FALSE means to provide a return only if an exact
match is found, otherwise an error message.

hth
Vaya con Dios,
Chuck, CABGx3




"Watercolor artist" wrote in
message ...
Chuck,

What if the lookup price was in Column C rather than B and that I wanted
to
ignore what's in B?

Also, in "A:B,2,FALSE," what exactly do those parameters mean?

Howard

"CLR" wrote:

In C2 maybe something like this...........

=VLOOKUP(A2,'C:\[Pricing.xls]Sheet1'!A:B,2,FALSE)*B2

You may have to adjust the Path, and SheetName and Range accordingly
Vaya con Dios,
Chuck, CABGx3



"Watercolor artist" <Watercolor wrote
in
message ...
I have a column in one spreadsheet (Call it "Orders") into which I
enter a
book name that I sell, a second column into which I enter a quantity,
and
a
third column into which the price is entered by looking up the book
and
quantity in a different spreadsheet (call it "Pricing") in a different
file,
finding the book's price, multiplying the quantity by the price, and
inserting that into the cell containing the lookup function. I don't
know
how
to write that formula and would appreciate help.