Fix template based on raw data sheet current and previous day

[farrukh]

Hi Experts!
I have a sheet named Template and Rawdata.
There are two tables in Template sheet one based on previous date data and one belongs to current date data. requirements to fill the template sheet based three criteria matched from raw data sheet.
1. Template sheet column F5 to column P5. with Rawdata sheet Column B
2. Template sheet column F6 to column P6. with Rawdata sheet Column C
3. Template sheet column G4. with Rawdata sheet Column A
4. Then fill the data to Template sheet column F7 to column P7. with Rawdata sheet Column D ( For previous date data suppose in the template sheet the date is 10-Apr-2020 so fix the data for 9-Apr-2020 in the first table and in the second table data for current date which is 10-Apr-2020.

The template sample is attached.

[Bo_Ry]

Please try at
F5
=LOOKUP(1,1/(Rawdata!$A$2:$A$23=$G4)/(Rawdata!$B$2:$B$23=F5),Rawdata!$C$2:$C$23)
F6
=LOOKUP(1,1/(Rawdata!$A$2:$A$23=$G4)/(Rawdata!$B$2:$B$23=F5),Rawdata!$D$2:$D$23)

[farrukh]

Sir Bo_Ry,
Thanks it works based on two criteria date and name.
Also required to work on third criteria which is sample column. Means all 3 criteria matches then the condition gets true and bring data from columnD Rawdata sheet.

[JeteMc]

To add the third criteria, sample, please modify Bo_Ry's formulas for the Data rows as follows:
For row 7: =LOOKUP(1,1/(Rawdata!$A$2:$A$23=$G4)/(Rawdata!$B$2:$B$23=F5)/(Rawdata!$C$2:$C$23=F6),Rawdata!$D$2:$D$23)
For row 14: =LOOKUP(1,1/(Rawdata!$A$2:$A$23=$G11)/(Rawdata!$B$2:$B$23=F12)/(Rawdata!$C$2:$C$23=F13),Rawdata!$D$2:$D$23)
Note that the formulas are array entered so after pasting them into their respective cells in column F press and hold the Ctrl and Shift keys while pressing the Enter key. Activate the formulas before copying them over to column P.
Let us know if you have any questions.

[farrukh]

JeteMc perfect thank you and Boy_Ry !

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.