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!!!!
@stevenmeyers1951
Жыл бұрын
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.
@thistoob
Жыл бұрын
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!
@johnburr9463
Жыл бұрын
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.
Пікірлер: 5