Home |
Search |
Today's Posts |
#1
|
|||
|
|||
arrays in excel
Hello,
What i'm trying to accomplish is to get a list of all po's (purchase orders) that we have on order for a certain part. What i need to do is to get a list of all po's associated with a certain part. part# po# A1:021-310L B1:107803 A1:021-310L B1:109851 What i'm trying to get excel to do is to place the data like this according to what part number is entered in the adjacent coloumn from another sheet containing the data shown above, i tried using the {=SUM(IF formula but that only added the po's, and =VLOOKUP only gives me the first one it finds. A1: 021-310L B1: 107803 C1: 109851 Much thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Formula Arrays VERY SLOW in Excel 2002 | Excel Worksheet Functions | |||
Problems with Excel Horizontal arrays with regional options using. | Excel Discussion (Misc queries) |