Lookup Values with Merge | Power Query | Excel Off The Grid

[@IvanCortinas_ES]

High quality explanation, as in all the videos on the channel. Very good job Mark.

[@ExcelOffTheGrid]

Thanks Ivan, I appreciate that😀

[@tlee7028]

Awesome video !

[@Sumanth1601]

Great content.. The approximate match was something new I learned.. Thank you.

[@ExcelOffTheGrid]

Thanks. 😀 The approximate match is a lot of steps, but contains a lot of useful transformations that can be applied in other scenarios.

[@davsbrander]

Very useful, did exactly what I needed to remove certain rows from a query. :) thank you!

[@ExcelOffTheGrid]

Glad it helped! 😁

[@Bhavik_Khatri]

Excellent tutorial.

[@ExcelOffTheGrid]

Many thanks!

[@tariqaziz783]

How can i calculate over time hours keeping in view the Sundays, if they work on holiday they are paid full hrs as overtime and rest days above 8 hrs is over time.

[@CDSeater]

You do get a problem with the approximate match when you have an exact match within it. For example if one of the customer total sales was 500.00

[@ExcelOffTheGrid]

What problem as you seeing? It looks right to me 🤔