Vlookup using multiple criteria

[adiles]

I have an excel sheet with details like, date, employee name, and worked hours, i want to display the same details in another sheet with date and hour only, if i type the employee name in one cell the function will have to look into the other cell to get the details

Date	employee name	hr
1-03-23	AAA	12.5
2-03-23	BBB	13.5
3-03-23	AAA	15
5-03-23	ZZZ	18

Employee name: AAA

Date	hr
1-03-23	12.5 (this data should be taken from the above excel)
2-03-23
3-03-23	15
4-03-23

 

[Joe4]

How about just using a SUMIFS?
You match on Date and EE Name, and sum the hr column.
If there is just one value, it will return that value.

 

[adiles]

How about just using a SUMIFS?
You match on Date and EE Name, and sum the hr column.
If there is just one value, it will return that value.

Its showing Spill

 

[Joe4]

Please post exactly how you have written your formula (we cannot analyze/critique it if we cannot see it!)

 

[adiles]

Please post exactly how you have written your formula (we cannot analyze/critique it if we cannot see it!)

Thanks, i did it with pivot table. Thanks for the support.