If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|