Hi Guys,
I have a formula that I use to look up a value according to 3 conditions. But when I reorder the rows using a sort & filter function, the formula locks for cells $C11 & $F11 are still locked to the original cell rows (but I don't wish to lock them). I want them to retrieve the value after the sort.
=IFERROR(LOOKUP(2,1/((Real!$F11='MILL'!$A$1:$A$100000)*(Real!$C11='MILL'!$B$1:$B$100000)*(Real!$J$9='MILL '!$C$1:$C$100000)),'MILL'!$D$1:$D$100000),"-")
Any help would be great.
Thanks,
Bookmarks