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?


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")
| improve this answer | |
  • 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 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 at 7:11

The simplest way


enter image description here

No need to over complicate things

| improve this answer | |
  • Of course, not flexible. – 4thSpace Mar 11 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 – marikamitsos Mar 11 at 17:43

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.