Dear `s
In the attached file I have 2 sheet, the first sheet name is SETUP and the second sheet is Data, in the SETUP sheet I highlighted column E2 from (E2:E40) to be my index data and I build my formula in second sheet, and it works fine except that It not showing the right index when the figure become >3 or >4 or >5 & >10 it showing #N/A.
Please in need your support & help to solve this error. I don’t need to use IF condition because the variables in this data is more than 80 records for each country.
BR
Bookmarks