Current Events > Any good Excel people? Simple question, I think

(+) Yeah! (+)

I want to do sort of a Vlookup with 2 reference cells, without having to use concatenate to merge them to one reference column. Below, A and B are the same as E and F, just filtered upside down to mix them up. Can I somehow reference both A and B to return the appropriate value of the C column for the E and F?

https://gamefaqs.gamespot.com/a/user_image/7/5/8/AANViFAAEcHu.png

@goatthief I hear you are good with spreadsheets

SUMIFS will help if you mean what I think you mean. Sum range would be column C, criteria range 1 would be column A, with criteria 1 being E2, with criteria range 2 being column B, and criteria 2 being F2. It will take the figure from column C that has A and B match E and F. If there are multiple rows with the same A and B, it would add together the values in C, but it doesn't look like you have that.