Returning values

[timjl]

I am trying to return values if a certain variable is met. Please see the enclosed spreadsheet.

What I am trying to do is return the value on row 4, column C -I, into column J if the value is greater than 20 in columns C - I.

Any help would be greatly appreciated.

[Ron Coderre]

Using your posted workbook, I see the data but I'm not sure what values you want returned and where you want them.

Can you post some sample results...embedded in a reply post would be acceptable.

[timjl]

In the example below see Bobby Abreu and Garret Atkins (the first and last names listed. Abreu had over 20 games in OF therefore OF appears under the column for Eligible. When looking at Atkins he had over 20 games at both 1B and 3B therefore 1B,3B appears under the column for Eligible.

Any help is appreciated, and I hope the chart below is what you were looking for.

PLAYER Team 1B 2B SS 3B C OF DH Eligible
Abreu, Bobby LAA 0 0 0 0 0 136 14 OF
Abreu, Tony AZ 0 1 0 1 0 0 0
Adams, Russ SD 0 0 0 0 0 5 2
Alfonzo, Eliezer FA 0 0 0 0 30 0 0
Allen, Brandon AZ 32 0 0 0 0 0 0
Amezaga, Alfredo FLA 0 0 5 0 0 18 0
Anderson, Brian BOS 0 0 0 0 0 83 0
Anderson, Garret ATL 0 0 0 0 0 124 1
Anderson, Josh KC 0 0 0 0 0 107 6
Andino, Robert BAL 0 8 62 2 0 2 1
Andrus, Elvis TEX 0 0 145 0 0 0 0
Ankiel, Rick STL 0 0 0 0 0 100 0
Arias, Joaquin TEX 0 2 0 1 0 0 0
Atkins, Garrett COL 28 0 0 78 0 0 5 1B, 3B

[Ron Coderre]

Without resorting to a custom function, try this in your sample workbook:

Please Login or Register  to view this content.

Copy that formula down as far as you need.

Does that help?

[timjl]

That worked perfect. Now for me to figure out exactly what you did.

Thanks a ton.

Tim

[timjl]

I just want to say thank you to everyone on this site that has ever helped me. I don't do a lot complicated stuff on Excel, but anytime I run into something that I can't figure out I know exactly where to go...here. Thanks again for all the help.

[Ron Coderre]

You are very welcome. We help because we enjoy sharing our
knowledge, but it is so much more rewarding when our efforts are
appreciated.