Can somebody look into this lookup function, it worked originally, now seems to only work for about 7 rows.
https://www.excelforum.com/excel-for...onditions.html