# Formula to find the cell in column C where a value in column A = a value in column E

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

## 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:

• Hey @marikamitsos, I've added a ss of how I want it to look. The formula would go into Column D May 16, 2020 at 5:26
• Please have a look at the updated formula. May 16, 2020 at 6:03
• Works perfectly! Thank you soooo much! I've been wrecking my brain on this for days! May 16, 2020 at 6:16
• Glad I could help :) May 16, 2020 at 6:17
• One last question, for the formula I have in Cell E2, how to I get it copied to all the cells in the entire column (e.g. 900'000 cells) instead of dragging it down? May 16, 2020 at 7:20