Hi all, first post here.

I'm trying to use VLOOKUP to lookup a value in a table that occurs more than once, then I can handle the rest of the task from there.

Basically: 
Please Login or Register  to view this content.
only returns the 3rd column of the first instance of "a2", but I need it to return the 3rd column for every instance of a2.

Thoughts?