Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do you achieve resolving the duplicate number problem
in Lookup. Such as: Freq Number 40 29 38 43 37 7 36 20 36 20 <---- should be 58 35 13 such as 36 and 20 in the above. There are two freq with number 36. How do you get VLookup to go past the first number 20, to the second number Freq (36), which in this case should be number 58. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup duplicate value | Excel Discussion (Misc queries) | |||
Lookup duplicate items in a list | Excel Worksheet Functions | |||
Lookup table with duplicate 'lookup_values' | Excel Worksheet Functions | |||
Lookup into tbl w/ duplicate values | Excel Worksheet Functions | |||
Index lookup and duplicate numbers | Excel Worksheet Functions |