I have the following formula which locates values in my array.
=IFERROR(INDEX(Data!$CW$12:$CW$35,MATCH(B72,Data!$DL$12:$DL$35,0)),"")
It works great as long as I don't have a duplicate value in "Data!$DL$12:$DL$35". How do I adjust this formula to account for duplicates?
Thank you.
Bookmarks