Index and Match Function

[kensbro]

Will this function work with an array that contain duplicate values?

 

[xld]

It might do, if we could actually see anything other than the question.

 

[Hui]

@Kensbro


Have a read of this post which shows a method for doing multiple lookups

http://chandoo.org/forums/topic/finding-a-match-when-there-are-multiple-items-in-a-cell