2

I'm sorry if this a simple and already answered question but I can't make work any of the answers I have tried (this one too).

I'm trying to auto fill or auto populate a row with data from another sheet. I have this list with a named range Food on column A: enter image description here

What I need to do is that when I select any of the on the other sheet the Protein, Fat an Carbs fields get auto completed. enter image description here

In this case, using Validation I can only select an option but don't know how to horizontally complete to the right with the data of the first table.

This is the spreadsheet

Thank you very much in advance for the help.

eera5607
  • 235
  • 2
  • 6

1 Answers1

2

Assuming Dish is in Sheet1 A1. Assuming Food is in Sheet2 A1.

In Sheet1 C3 and copied down to suit:

=query(Sheet2!A:D,"select B,C,D where A='"&B3&"'",0)
pnuts
  • 56,678
  • 9
  • 81
  • 133
  • Thank you @pnuts it worked great... Can you please check [this other question](https://stackoverflow.com/questions/53355450/sum-vertically-until-empty-cell-on-google-sheets)? – eera5607 Nov 17 '18 at 20:51