| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Muchas gracias, Chuck. Your solution worked perfectly.
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
| Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
| Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
