Hello,

I have  list with more than 5000 items, I'm trying to use lookup function  to that list in calculated field to get a value. 

It is simple lookup which looks like this lookup("PO","Title", Control on form,"VALUE"). It is showing #value! error right from the start. Is it possible to use a lookup function for a list with more than 5000 items? Strangely, I have another list which has more items than this one, I'm able to use the lookup to that list. What am I doing wrong?