I have a table that sometimes has duplicate entries in a column. I'm doing a VLOOKUP on this column, however, obviously, if there is more than one match, this generates an error.
What I'd like to do is return a match for the most recent duplicate entry, or in the case of a sheet that is filled via a form, the item farther down the sheet than all other duplicates.
Any suggestions how this could be accomplished?
Thanks