How to Return a row based on Values in a given Column?

**globulous** · 10-27-2009, 10:41 AM

I've just learned how to use the SUMIF function, and this question is similar but a little more complex..

I want to scan through a column for particular values, and return the entire row that those values belong to (return it to another sheet ideally).

Is there a function that does this, or is this macro material?

**Palmetto** · 10-27-2009, 10:46 AM

The answer depends on how your data are structured, but you will need to use one of the Look UP functions, such as VLOOKUP or possibly a combination of Index/Match functions.

See here for ehlp on thise functions: Contextures

You might want to upload a sample workbook with a bit representative date and manually show the desired results so we have a better idea of how to answer.

**globulous** · 10-27-2009, 11:18 AM

Here's a sample..

I want to be able, ideally, to have a little 'search' box set up so i can specify
1) Whether i'm looking for Away or Home or BOTH (Column C or G or, C AND G)
2) The specific team i'm looking for.. (teams from either column C or G, depending on home or away)

So, for instance, i want to find "MTL Away" games... i'd like to be able to input this somewhere and have Rows 1, 16 and 34 copied from "Schedule" to Row 1 on the sheet, "Teams"

does that help?