Forum Discussion
Solved
Need some help with my Vlookup or a new idee
Hi I have a table of 16087 rows and 7 columns. and im strugling with similer names in column A and Vlookup that picks the first hit. This is a dogbreed that have dogs with simple names and i want ...
Hi Jimmy,
I was not able to convert your text back to Excel sheet from my browser, at least for reasonable time. Here is the sample which illustrates the idea
Entire formula to find Reg No is
=INDEX($C$3:$C$10,MATCH(AGGREGATE(14,6,1/($B$3:$B$10=$F$3)/($G$3>$D$3:$D$10)*$D$3:$D$10,1),$D$3:$D$10,0))
Here AGGREGATE find the largest date in Date column for which Name=a
($B$3:$B$10=$F$3)
and date is less than Born
($G$3>$D$3:$D$10)
You may add here more criteria if needed.
MATCH find position of that date in Date column and INDEX returns Reg No for that position.
Please see attached.
If I understand your issue correctly, you have an issue with the VLOOKUP Function discriminating between duplicate or similar names. Try making a new column an Concatenate the Name and the Date in question. Something like "Smokey_1965" and then use the VLOOKUP Function on the new column. Hope this works :-)