Hmm...I figured it would look something like that (I read INDEX/MATCH is better than VLOOKUP), but I'm getting an error message due to the array. Pressing F2 and F9 or CTRL+Shift+Enter doesn't help. I'm not very familiar with arrays, so I assume I'm just doing something wrong. Any ideas?
|