I want to unique lookup from another file and multiple sheet. However, if the data contain in Sheet A while the data range in SheetA contains 400.000+ rows, so the function can’t lookup. The formula below.