OK, this is a little hard for me to explain but here it goes:
I have 2 worksheets in a workbook.
The first sheet has four columns. They are called: Player, Round, Pick, and Overall. Player is just text (a person’s name), and the other 3 columns are all integers.
The sheet has two columns. They are Player and Draft. Player is just a person’s name (the same as in the first sheet), and I’m trying to make a formula for the Draft column.
What I want the formula to do is take the information from the Round, Pick, and Overall columns, and to combine it into one cell. I would want to display in the form Rd X, Pk Y, (Z). X,Y,and Z represent the values in the round pick and overall columns from the first sheet. An example of an output I’d be looking for would be “Rd 2, Pk 4, (16)”.
Basically, I want to be able to type in a player’s name on the second sheet, and have the round he was picked, the pick in that round, and the overall pick he was show up in the next cell.
I’m pretty sure I either know, or could figure out, how to make this work if I wanted to use 3 different columns on the second sheet, but my real question is if there is a way to format so it all comes out in one cell.
I realize that this probably doesn’t make much sense, and I’m having a real hard time explaining myself. I’ll try to clarify if anyone has any questions, and if this is too confusing, just ignore this whole post.