Cross sheet conditional lookups

Hi all

On the attached "1901 - EcoBat..." spreadsheet, in the "Project Summary" tab, I have linked column B to another spreadsheet to automatically pull through the budget costs based on the job number inserted into cell B7. What I now need to do, is make those budget values increase when I receive instruction to carry out further works (variations). I have a log which is used to store variations costs "Variations List", and mark whether they are approved or not by clients. This sheet is also attached.

What I need to do, is when a variation is approved on a project, marked approved in column G of "Variations List", is that all of the values from columns J-P pull through to the "1901 - EcoBat..." spreadsheet onto the "Project Summary" tab and into their respective sections in column B.

Help is greatly appreciated! If I need to provide any other info please let me know!

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #2 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...-look-ups.html

Thread closed.