VLookup doesn't display duplicate values in Excel for some reason? Any suggestions?

Question

Hello all, I am working on an Excel spreadsheet for my NFL tournament, and after some weeks, people's scores are tied. When I use the "VLookup" function to sort the people with the most points to the least points, if somebody's scores are tied, the first persons name shows up, but the 2nd person gets "#N/A" in their field.

I would look for their score to be displayed as well, how do I go about doing this?

My VLookup function looks like so:
=VLOOKUP($AI4,$A$4:$T$32,2,FALSE)

*AI4 is where the persons name comes up
*A4:T32 is the array of the table that I am working with
*2 is the column of the people's names

Your help is greatly appreciated

Answer 1

VLOOKUP will only find the 1st value that matches the look-up value (AI1). There is sort of a work-around I can suggest.



If A4:A32 are the total scores for each person, you can make it so that the totals are never exactly equal by adding an insignificant amount to each total.



Say A4 has the formula =SUM(C4:T4)

And A5 has the formula =SUM(C5:T5)



Change the formulas to this

A4 =SUM(C4:T4) + (ROW()*.0001)

A5 =SUM(C5:T5) + (ROW()*.0001)



This will add a small amount to each total of the row number of each cell times .0001. Then format each cell so they don't display the decimal values.



Because each person's total is in a different row, they will never be exactly the same but they will look tied since you've rounded off the decimals. Excel will still use the decimals when you do a look-up though.



When you do a look-up use this formula to get name of the person with the the largest score

=VLOOKIP(LARGE($A$4:$A$32, 1), $A$4:$T$32,2,FALSE)



2nd largest score

=VLOOKIP(LARGE($A$4:$A$32, 2), $A$4:$T$32,2,FALSE)



Hope that helps or gives you some ideas.



Alternatively, you could select A4:T32 and select from the menu Data\ Sort and sort on the column that has the scores.

Answer 2

Position your bets to gain is easy with the Zcodes System from here https://tr.im/qfvDo .

Zcodes System is a really precise program since the predictions are created by considering up many applicable facets; the accuracy of the predicted result is extremely high.

You'd believe it is nearly impossible to factor in so many features and produce the forecast as precisely on your own for even one sporting function, not to mention a complete day's betting's worth.

Zcodes is constantly being updated.  It's not an e-book.  It's a full time income, breathing, sports investing system.  

Zcodes System does the hard meet your needs since is really a system that hold it fresh.

Answer 3

If you ever wondered if is there a betting program that may offer you a higher proportion of winning bets than losing one's then you should know that this technique exist, is here now https://tr.im/LNlu9 , Zcodes System.

Zcodes System is the very best activities investing software/system.  Ron, Mike, Steve, and their team of programmers spent over 24 months beta-testing Zcodes before even launching it stay and it certainly shows. 

If you wish to earn money, a bundle then, employs Zcodes System.

Answer 4

you have *AI4 is the place the persons call comes up did you mean that AI4 is the persons score you are attempting to examine? is column A of your table the persons score? and is the persons call in column B? be at liberty to replace, and enable me comprehend if i'm examining this incorrect.