I have 5 rows with 10 columns. Below this 5x10 grid, I populate a cell with a value that is listed in column 1 of the grid. "ABC" for example.

If "ABC" is row 3, column 1, I want to them get the values in row 3, columns 4, 5, 6. Those three values will go into cells just above or below the "ABC" cell that is below the grid.

The value where "ABC" is will change, as I get info from different rows, but will always correspond to a value in column 1 of the 5x10 grid. Any ideas on how to do this?

  • Please read how to and share a test sheet so as you can be easier helped. Mar 11, 2020 at 14:51
  • There are other, simpler ways to do that. Is LOOKUP a must? Mar 11, 2020 at 16:21

2 Answers 2


In Test Sheet A10 is your "ABC" cell and below find the formula that returns Values from columns 4,5,6 (or any other - just add)

"select Col4, Col5, Col6 
where Col1 ='"&A10&"'",0),"no data")
  • Perfect! By the way, did you share that sheet anonymously? I don't see any identifying info on it. If so, can you say how?
    – 4thSpace
    Mar 11, 2020 at 17:34
  • @4thSpace I just get shareable link, so anyone on the internet can see it. you can find info on Share\Advanced
    – Oleg_S
    Mar 12, 2020 at 7:11

The simplest way


enter image description here

No need to over complicate things

  • Of course, not flexible.
    – 4thSpace
    Mar 11, 2020 at 17:41
  • Your question is "... I want to them get the values in row 3, columns 4, 5, 6." Those values are not flexible Mar 11, 2020 at 17:43

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.