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

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