Learn data skills at our academy and elevate your career. Start for free at ftdacademy.com/ Download the Excel workbook used in this video here ftdacademy.com...
I like INDEX MATCH as it is made up of two functions. The MATCH function is used to figure out where the lookup value is located in a range of cells. The INDEX function then returns the value or cell reference from within a table or range. The MATCH and INDEX functions are combined to do the job that VLOOKUP cannot do.
I learned IM 20 years ago & when I used it as an analyst I loved it. But advancing in my career made it fall out of my regular toolbox. Now I am befuddled on how it works!
I already use those and yes, they are powerful. Sometimes i even use those in spreadsheets I've built to help me write certain SQL scripts. But the case is very edge.
Wasn’t aware of the XLookup! Saves me from duplicating collums and counting the nr of collum in an array all the time. So great tip again Ben, tx!!!!
I like INDEX MATCH as it is made up of two functions. The MATCH function is used to figure out where the lookup value is located in a range of cells. The INDEX function then returns the value or cell reference from within a table or range. The MATCH and INDEX functions are combined to do the job that VLOOKUP cannot do.
I learned IM 20 years ago & when I used it as an analyst I loved it.
But advancing in my career made it fall out of my regular toolbox.
Now I am befuddled on how it works!
I already use those and yes, they are powerful. Sometimes i even use those in spreadsheets I've built to help me write certain SQL scripts. But the case is very edge.