View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Can I use a lookup on data containing duplicate entries?

Yes you can.

Please hit Yes if my comment has helped.

Thanks.




"City6" wrote:

I'm using Excel 2007. I'm trying to sort data retrieved from a large data
dump that combines both numbers and text. Can I use the V-Lookup function if
the data contains duplicate entries? Or would another formula be more
adequate?