return value from cell in col C when value in col A = "valueX" AND col B = "valueY"

[amirah_almu7aka]

Hi, i have a question regarding this specific problem: i have 3 columns filled with string values and i want excel to return the value from the cell in column C when value in column A = "valueX" AND column B = "valueY"

How can i do this? i guess a Vlookup doesn't work...

Thanks very much!

[Fotis1991]

hI. tRY.Hi. Try.

=IF(AND(A1="VALUEX",B1="VALUEy"),C1,""))

[NBVC]

If column C are numbers, and you have a unique list you can use SUMIFS

e.g.

=SUMIFS(C1:C100,A1:A100,"ValueX",B1:B100,"ValueY")

if valuex and valuey are numeric, you don't need the quotation marks...

if column C is text, then try:

=IFERROR(INDEX(C1:C100,MATCH(1,INDEX((A1:A100="valueX")*(B1:B100="ValueY"),0),0)),"")

[Richard Buttrey]

Hi,

You don't say what you want if the condition isn't met, but try:

=IF(AND(A1="valueX",B1="valueY"),C1,"default value")

[amirah_almu7aka]

If column C are numbers, and you have a unique list you can use SUMIFS

e.g.

=SUMIFS(C1:C100,A1:A100,"ValueX",B1:B100,"ValueY")

if valuex and valuey are numeric, you don't need the quotation marks...

if column C is text, then try:

=IFERROR(INDEX(C1:C100,MATCH(1,INDEX((A1:A100="valueX")*(B1:B100="ValueY"),0),0)),"")

Thanks a lot! This worked like a charm! I had to change it a bit though, now it looks like this: IF(ISERROR(INDEX($C$1:$C$100, MATCH(1, INDEX(($A$1:$A$100=$Z$1)*($B$1:$B$100=$Z$2), 0, 0), 0), 0))

[amirah_almu7aka]

and also thanks for the other replies of course!