Index - Match is amazing. It's a little wonky to get your head around the first few times, but once you have it, it's incredible.
That first range of cells is the data you are looking for - what you want to show up when you're done. The individual cell reference is what you're looking up to find it. The second range of cells is where your key data value you are looking up is.
|