Google-sheets – Formula to find the cell in column C where a value in column A = a value in column E

google sheetsgoogle-sheets-arrayformulavlookup

I'm trying to create a formula in a google sheet to find the value in the C column where the value in the A column is equal to the value in the E column.

E.g. Column E = 1 in Row 9-16 and Column A = 1 in row 2, therefore, show what's in Column C row 2

Column E = 2 in Row 17-24 and Column A = 2 in row 3, therefore, show what's in Column C row 3

Best Answer

EDIT

(following OP's edited question)

Please use the following in cell D2:

=ArrayFormula(IFERROR(VLOOKUP(E2:E,$A$2:$C,3,0)))

Original answer

Please use the following formula:

=ArrayFormula(IF(A2:A13=E2:E13,C2:C13,""))

(of course you can adjust the ranges to your liking)

If on the other hand need to show the results as in your example, use this one:

=VLOOKUP(E16,A2:C,3,0)

Functions used:

Related Solutions

Google-sheets – How to get value of cell by row key and column key

If you're looking for just the GDP of France then this will do:

=VLOOKUP("France",data!A2:C,2,FALSE)

Google-sheets – Suming values in a column if value in cell next to it matches another cell

This is the solution I came up with after digging around some more:

=SUMIF(C:C, INDIRECT("RC[-1]", false), D:D)+SUMIF(G:G, INDIRECT("RC[-1]", false)

This enables me to compare the first range to value left to the cell I'm currently in and if it's a match, analogue value in the second range is added to the sum. Adding two of those together enables me to sum multiple ranges if I want.

INDIRECT("R[x]C[y]", false)

This command references the cell which is x rows and c columns away from the cell which contains this command. False is there so relative RC referencing is used instead of absolute A1 referencing.