https://youtube.com/watch?v=ugf97S8r9PA#shorts #excel #index #indexmatch #match If you want to do a reverse lookup in excel 2019 or in an older version of excel, you can use INDEX with the MATCH…
https://youtube.com/watch?v=_DwvMFhH9ns#shorts #vlookup #vlookupformula by using VLOOKUP with MATCH you can lookup your data in a dynamic way. MATCH functions provide column index number to the VLOOKUP function based on your…
https://youtube.com/watch?v=I-SKjkqCHLA#shorts #excel #exceltips #conditionalformatting If you want to highlight a row based on condition you can use formula inside conditional formatting to do the same. by uisng formule you can…