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

1 Answer 1



(following OP's edited question)

Please use the following in cell D2:


enter image description here

Original answer

Please use the following formula:


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


Functions used:

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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