| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I select price from sheet.b where sheet.a part no = sheet.b
Hi all,
how do I select price from sheet B where sheet A part no is equal to sheet B part no. E.g. I have a list on worksheet A with no price. SHEET A PartNumber Description Price 0000001 0000002 0000003 0000004 0000005 0000006 0000007 I have a list on worksheet B with values for price, I need these prices for the same part no as on worksheet A to populate the price column on worksheet A. SHEET B PartNumber Price 0000001 1.50 0000002 0.80 0000003 0.30 0000004 2.50 0000005 6.00 0000006 3.80 0000007 1.20 I cannot simply sort and copy the price information, as there are many inconsistencies between these two worksheet some of the part no's may be there some may not, but for any that are there I need the price. Regs, Sonny. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose unique values in one column/mult. rows into a single row | Excel Worksheet Functions | |||
| select part of a cell value string | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| Select part of a cell | Excel Worksheet Functions | |||
| Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Threaded Mode
