GRAB VALUES FROM COLUMN A WHERE COLUMN C = 302

G

Gluefoot

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
 
T

T. Valko

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.
 
Top