1

I manually typed the info in Column D but that's how I want the answers to populateI'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

Improve this question
2

EDIT

(following OP's edited question)

Please use the following in cell D2:

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

enter image description here

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:

Improve this answer
  • Hey @marikamitsos, I've added a ss of how I want it to look. The formula would go into Column D – Kedar May 16 '20 at 5:26
  • 1
    Please have a look at the updated formula. – marikamitsos May 16 '20 at 6:03
  • Works perfectly! Thank you soooo much! I've been wrecking my brain on this for days! – Kedar May 16 '20 at 6:16
  • Glad I could help :) – marikamitsos May 16 '20 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? – Kedar May 16 '20 at 7:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.