Hi,
could you post an example, it will help to see what you want to achieve.
Thanks

"Mike" wrote:

can vlookup be used to find multiple matches in a table on sheet 2 for a
single index number on sheet 1?