Can I use a lookup on data containing duplicate entries?

C

City6

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?
 
J

Jim Thomlinson

Vlookup or any of the lookup type functions will return a match if a match is
found. If you have duplicate entries then it will return one of the entries
but you will have no way of knowing which one you got. What exatcly are you
wanting to do? Did you want a single total of all of the matching entries or
did you want a listing of the matching entries...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Cannot sort a table containing text 5
Data Validation /w Duplicate Entries 3
Sorting by rows with differing numbers of cell entries 3
Use TODAY() function as the criteria in a SUMIF formula 1
lookup and return column number 2
Sort by Large, Offset from Match, Duplicate values problem 2
Need V-Lookup to Return A Row, Not Just Single Value 2

Top