That didn't work. In the entire L column (movement tab) I want the formula to lookup cell F2 (PR tab) and return that number in column L but when the 100 is received in cell D4 (movement tab) I want the same formula to then return the number in G2 (PR tab), which its not doing in L2 and L3
Bookmarks