7

Teaching a colleague to use INDEX / MATCH in Excel
Me: Type in =MATCH() and select the reference cell, the column its in, and put 0 for the last value.
Them: OK... Done
Me: Now type in =INDEX() and select the column you want to match with, then put in the value you got from MATCH()
Them: OK... Done
Me: Now combine the two formulas
Them: How?
Me:...

Comments
  • 1
    The dude is right, instructions are not clear.
    I got stuck in thr toilet just readding this, please make it clear.
Add Comment