Need Help with an excel formula.

[cboissonnault]

I have an Excel Workbook that has 2 sheets.

The first sheet, is of my Job Details, and the sheet is named 'GBR Job Details' On this sheet, in Column A, is the Job Names, Column T, is the total number of tasks for the job, and Column W, is the Remaining tasks for the job.

The second sheet, is the Production details, and the sheet is named 'GBR Production' On this sheet, in Column A, is the Job Names, and Column F, is the number of tasks completed.

What I am looking for, is to somehow be able to enter in the Job Name and the number of tasks completed in the 'GBR Production' sheet, and back on the 'GBR Job Details' sheet, have it automatically enter in the Remaining tasks for the job based on matching what is entered in the 'GBR Production' sheet in Column A, tasks completed for that job.

Please reach out and ask me if there is any question. I really would like to get this Workbook up and running properly, as it tracks our Jobs and production.

Thank You.

 

[SanjayGMusafir]

What I am looking for, is to somehow be able to enter in the Job Name and the number of tasks completed in the 'GBR Production' sheet

To the extent I have understood your problem the above can be achieved through XLOOKUP formula provided Job Names in Both sheets are same. Any discrepancy will lead to error.

Same can be done for Jobs remaining.

What I understand it is a simple lookup problem and with Excel 365 in your hand XLOOKUP can be the best.

Try your hands with it - Check here - XLOOKUP Function. If any problem we are there...