How to find the 2nd instance of a value in VLOOKUP

English
#1

Finding the first is easy, but how do you find the 2nd?

#2

VLOOKUP() isn’t the appropriate function. (It’s very limited anyway.)
You will need helpers. See attached example:
disask99681_FindRepeatedInstance.ods (20.7 KB)

#3

Thank you so much. I don’t understand it but that’s easily fixed with effort.

Thank you again.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.