Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have set up a vlook function and I am returning peoples names for a given
array of data, however if multiple people share the same data in this case percentage points it will return the same name over and over. I am not very good with "IF" statements but I am assuming that is what I will need to use to resolve this issue. i.e. I am looking up 80% and Doug and Justin share that score, so for the the two scores of 80% it is returning Doug twice instead of Doug once and Justin once. How do I get it to return one and then once that name is used than return the other one when that score appears again? Sorry for the question not being articulated very well. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
#N/A value is returned | Excel Worksheet Functions | |||
#value returned instead of data | Excel Worksheet Functions | |||
Using the returned value of a function | New Users to Excel | |||
Result not being returned | Excel Worksheet Functions | |||
#Value! Returned ? | Excel Worksheet Functions |