INDEX MATCH TWO VARIABLES | pull through a value based on matching two cells | index match help
Hey guys!
Today we are looking at index match two variables in excel- that is how to pull through a value based on matching two cells.
In this video we take a look at what is index match (index match help) using a basic index match example and also along the way: how to lock cell reference on a mac and how to array function on a mac.
Timestamps:
1:13-1:25 how to lock cell references on a mac
2:33- 2:43 how to use an array function on a mac
With this easy to understand index match example (using very basic index match), you will be able to answer:
"how to index match on a mac?"
"when can i use index match?"
... and hopefully, be able to spot "why does my index match not work!?"
After watching the tutorial you should be able to pull through cell contents based on matching two criteria (index match two cell references/ index match two items)
Any questions let me know below!
🎼 Lofi Hiphop Mix 2022 | Lofi beats to study | No Copyright Lofi Hip Hop 2022
• Lofi Hiphop Mix 2022 | Lofi beats to study...
🎨 https://www.pexels.com/@anna-nekrashe...