View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
City6 City6 is offline
external usenet poster
 
Posts: 1
Default Can I use a lookup on data containing duplicate entries?

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?