I have a sheet, with 3,042 rows, and 4 columns. They are results of basketball games. I want to search the 3,042 rows for say "Duke" and then take that row and put it in another sheet. So basically I want to take my 1 sheet full of data and break it down into teams. If thats not possible, I could also be satisfied with searching the big sheet for "duke" and determing if the 2nd column is bigger than the 4th column.

I'm essentially trying to figure out if the result posted is a win for Duke, or a loss. Anyone got any help?

I did this " (=vlookup("Duke", ncaa3, 2) " and it gave me the last recorded score for duke.

any help would be appreciated...