Hello,

I have a problem with a vlookup formula.

I have a value in cell AM2 wich has this formula : 
=IF(DataBase!B2="","",DataBase!B2)
I have a table called ManagersData in my Database sheet.

In cell C3 I am using the follwing formula:
=IF(ISERROR(VLOOKUP($AM$2, INDEX(ManagersData, SMALL(IF($AM$2=INDEX(ManagersData, , 1), ROW(ManagersData)-MIN(ROW(ManagersData))+1, ""), ROW(2:2)), , 1), 2, FALSE)),"",(VLOOKUP($AM$2, INDEX(ManagersData, SMALL(IF($AM$2=INDEX(ManagersData, , 1), ROW(ManagersData)-MIN(ROW(ManagersData))+1, ""), ROW(2:2)), , 1), 2, FALSE)))
and copying this down.

It should bring me all the values that are looked up for cell AM2 however it is only displaying 5 values instead of 6 and I don't understand why. All the cells formating are the same and I've tried to create a new spreadsheet and the problem still persist.

Any ideas please??