LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 116
Default Duplicate Lookup

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup duplicate value :)[_2_] Excel Discussion (Misc queries) 7 February 16th 10 01:37 AM
Lookup duplicate items in a list Niall Excel Worksheet Functions 5 September 6th 08 03:06 AM
Lookup table with duplicate 'lookup_values' Greggers Excel Worksheet Functions 7 June 12th 08 08:45 AM
Lookup into tbl w/ duplicate values Matt R Excel Worksheet Functions 2 December 2nd 06 05:29 PM
Index lookup and duplicate numbers Ted Metro Excel Worksheet Functions 8 August 3rd 05 01:46 AM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"