I have two Workbooks - one (Book1) is an automatic tax calculator where you enter the Gross in A5 and the tax withheld appears in B5, and the other (Book2) is a fortnightly pay calculator. I want to have Book2 show the total in Book1!B5 when the number needed in Book1!A5 is found in Book2. I hope that isn't confusing!
Solved by V. Q. in 14 mins