OK, I'm trying to add one final piece to an NBA spreadsheet I've been working on. On a separate sheet I have the name of every team, along with the average points they give up to each position. It looks kind of like this;
Column G contains B:F in that order.
<tbody>
</tbody>
<tbody></tbody>In my template the Rows containing the player's position and the opponent that day are adjacent. I'm hoping someone can help me figure out how get '50' to appear in a cell when "PHO" populates the opponent column, and "PG" populates the Position column.
I'm not asking for someone to write a Macro for me, I'm hoping this is a one liner. If it's not, I'll go back to the drawing board.
Thanks!!
Column G contains B:F in that order.
<colgroup><col span="7"><col></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||
<tbody>
</tbody>
<tbody></tbody>
I'm not asking for someone to write a Macro for me, I'm hoping this is a one liner. If it's not, I'll go back to the drawing board.
Thanks!!