Thank you both! I feel kind of dumb for not thinking of the concatenating/vlookup option since I have already used both formulas elsewhere in this spreadsheet! But I know I have done it (I thought with an Index/Match formula) before in a single cell; so that's really what I was looking for. But that was a great quick fix!

----------------------------

use an index/match
=INDEX(Sheet2!$C$1:$C$200,MATCH(B2&C2,INDEX(Sheet2!$A$1:$A$200&Sheet2!$B$1:$B$200,0),0))
This is exactly what I was trying to do, but couldn't make it work (it does now - thanks)! Apparently I don't really understand the formula though. Would you mind breaking it down for me?

Thanks!