Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicate value causes VLOOKUP issue...
Column A (A1:A15) displays ranked values (from 1 to 15) from quiz results
using the formula: =RANK(P1,P1:P15,0) from scores in column P. Column B (B1:B15) displays Team names. To display results of the ranking for the top 5 teams, cells C20:C25 contain numbers 1 - 5, and cells D20:D25 contain formula: =VLOOKUP($C20,$A$1:$B$15,2,FALSE). Problem: If two teams happen to tie for 1st place (for example), the VLOOKUP in D21 will fail because there is no value equal to 2 in A1:A15 range. How can/should I deal with that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup issue | Excel Discussion (Misc queries) | |||
vlookup issue on Mac | Excel Discussion (Misc queries) | |||
VLOOKUP issue | Excel Discussion (Misc queries) | |||
VLOOKUP issue | Excel Worksheet Functions | |||
VLOOKUP issue | Excel Worksheet Functions |