Changing formula based on player's name

**ak20** · 04-25-2018, 04:39 PM

I recently created a small database full of NFL players that is split into different positions (linebackers, cornerbacks, quarterbacks, etc.). I also have a spreadsheet in it dedicated to finding a best comparable player at their specific position. In this sheet, there is a list of players at that position, a drop-down list of player names and a formula that refers back to the positional sheets, searches through the players (using different metrics like height, weight, arm length, 40 yard dash and college production) and eliminates less comparable players until a significantly narrowed down list of players remains. Any blank spaces in the first column just means that that particular player didn't fit a particular threshold, so they were eliminated

BestComparable.png
BestComparable2.png

What I'm having trouble with is when I'm done applying that formula to the first player on the drop-down list and then select a different player's name, the results come up as FALSE.

BestComparable3.png

Is there any way I'd be able to have it automatically apply the same formula to the player selected based on their name? Any suggestions would be greatly appreciated!

**protonLeah** · 04-25-2018, 05:37 PM

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

Click Advanced next to Quick Post button at the bottom right of the editor box.
Scroll down until you see "Manage Attachments",
Click the "Choose" button at the upper left (upload from your computer).
Select your file, click "open", click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Close the Attachment Manager window.
Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

**ak20** · 04-25-2018, 07:01 PM

Here is the workbook. If anyone could help me figure this out, I'd really appreciate it.

**JeteMc** · 04-30-2018, 09:45 PM

Hello AK20 and Welcome to Excel Forum.
It seems to me that the comparisons are supposed to change as the name in cell A1 changes. The existing formula doesn't allow for that as all stat comparisons are locked to those of Richard Sherman (CB! row 2) as in: ...IF(CBs!F2>(CBs!$F$2+2),"N/A"...
It would seem that in fact all the comparisons should be to the CB whose name appears in cell A1 as in: ...IF(CBs!F2<INDEX(CBs!F$2:F$484,MATCH(A$1,CBs!B$2:B$484,0))-2,"N/A"...
In the attached file the formula that populates column A of the CB Comparison sheet has been modified so that all comparisons are to the stats of the CB whose name is in cell A1.
Let us know if you have any questions.

**ak20** · 05-01-2018, 12:21 PM

Thank you very much, JeteMc!!!! I've been trying to figure this out for over a week now and it was really starting to annoy me (so much so that I searched for assistance on at least five different websites), but thankfully your edit works perfectly and gave me exactly what I was looking for! Although it's not enough to express my gratitude for your assistance, I just want to thank you again!

**JeteMc** · 05-01-2018, 07:20 PM

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools drop down in the ribbon above your first post. I imagine that the other websites would appreciate your letting their contributors know that the question has been answered as well.
I hope that you have a blessed day.

Changing formula based on player's name

LinkBack

Thread Tools

Rate This Thread

Display

Changing formula based on player's name

Re: Changing formula based on player's name

Re: Changing formula based on player's name

Re: Changing formula based on player's name

Re: Changing formula based on player's name

Re: Changing formula based on player's name

Thread Information

Users Browsing this Thread

Similar Threads

How to Create Randomized Teams for a Golf Scramble Based on Player Ranking.

[SOLVED] Knockout round> Player A vs Bye? Player A go through? How get automatic without score in?

[SOLVED] Combine two column using formula and based on player name

[SOLVED] formula to get the name of the next player with the same score

Automatically Place Player Based Results & Player Ranking

[SOLVED] Media Player versus Windows Media Player

Media Player versus Windows Media Player

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions