Google Sheets Tutorial for Beginners - 18 Bite Sized Lessons in 30 Minutes

[@techbasics1264]

Would making the practice files available be helpful? Please comment below to let me know what you think.

[@migsjashensofia]

How to edit the cells without changing the search_key but instead the lookup_range only as for my example i want to change this
=XLOOKUP(B63,EMP!B3:B3000,EMP!O3:O3000)
=XLOOKUP(B64,EMP!B5:B3002,EMP!O5:O3002)
=XLOOKUP(B65,EMP!B5:B3002,EMP!O5:O3002)
=XLOOKUP(B66,EMP!B7:B3004,EMP!O7:O3004)
This happens when i drag it down and i have to manually edit each cells lookup_range to EMP!B3:B3000,EMP!O3:O3000.