Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
GRAB VALUES FROM COLUMN A WHERE COLUMN C = 302
I need to lookup the values in sheet 1 column A where the corresponding value
in column c = "302" I don't want it to grab any values that are blank or not equal to 302. can someone help? i'd like to list these in column A of sheet 2 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
GRAB VALUES FROM COLUMN A WHERE COLUMN C = 302
One way...
Sheet2 A1 = formula to get the count of records that meet the condition: =COUNTIF(Sheet1!C:C,302) Enter this array formula** in Sheet2 A2 and copt down until you get blanks: =IF(ROWS(A$2:A2)<=A$1,INDEX(Sheet1!A$2:A$20,SMALL( IF(Sheet1!C$2:C$20=302,ROW(Sheet1!A$2:A$20)),ROWS( A$2:A2))-ROW(Sheet1!A$2)+1),"") ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Gluefoot" wrote in message ... I need to lookup the values in sheet 1 column A where the corresponding value in column c = "302" I don't want it to grab any values that are blank or not equal to 302. can someone help? i'd like to list these in column A of sheet 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
Count cells w/values in column if the data in column a matches cri | Excel Worksheet Functions | |||
Autosum column values, if separate column values equal certain val | Excel Worksheet Functions | |||
Numeric reference of column. Data Grab ? | Excel Discussion (Misc queries) | |||
To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions |