Google Sheets

[Guard913]

So I am trying to create a Formula to do something very particular. To start off I created a Demo Google Sheet so it can be easier. Demo Sheet

If you click the Demo Sheet link you should be able to edit that Page, and I can see you as you edit.

So, the idea is in A2 when AAA is Selected Data From B13 populates B2, and Data From C13 Populates C2. A2 when Done will have over 100 Options and when I select one I want it to auto populate the information, and so on, and so forth.

Now, the Big Goal is to have all the information come from a Different page in the same workbook that way I can keep each page as tidy as possible, of course new items will be added so I assume I would need to change certain parts of the formula from time to time. However the change would most likely be small.

This is my first time here, but this is probably <gs id="b5dfd9a4-3758-4ab5-8966-14e7bd769981" ginger_software_uiphraseguid="45641536-f81f-492b-90b1-5034654db090" class="GINGER_SOFTWARE_mark"><gs id="a3ad1e38-87d4-46ec-9fba-d7cb7f525381" ginger_software_uiphraseguid="17b83d16-fe01-40f2-b5a2-39808946bfbc" class="GINGER_SOFTWARE_mark">been</gs></gs> the question I have tried to answer on my <gs id="86bcd9cb-8658-491c-bc70-4f483274da00" ginger_software_uiphraseguid="45641536-f81f-492b-90b1-5034654db090" class="GINGER_SOFTWARE_mark"><gs id="71a364b8-e371-4541-ba4e-0fb3c9b3a075" ginger_software_uiphraseguid="17b83d16-fe01-40f2-b5a2-39808946bfbc" class="GINGER_SOFTWARE_mark">own but</gs></gs> none of the formulas I try are even close to working. I am a Basic Excel User Complex <gs id="c4337626-fa48-4208-a44e-ac67d2e2c8a9" ginger_software_uiphraseguid="e145dd42-d01a-4fa6-be83-82a105df57b1" class="GINGER_SOFTWARE_mark"><gs id="b6ee05e3-aa1f-4596-ac18-17086cb7d9cd" ginger_software_uiphraseguid="6a3a2858-f3c1-4337-a042-3669389b59db" class="GINGER_SOFTWARE_mark">formulas</gs></gs> just baffle me.

Thanks

 

[Guard913]

I feel like an idiot
Here is what I should have used: LOOKUP(A2,H2:H3,I2:I3)
I was using VLookup instead....... Moderators can delete, close this. Oh the shame..... lol

 

[Michael M]

No need to feel like an idiot, at least you worked it out !......it's amazing the number of times people write things down and post......only to have that lightbulb moment 30 seconds later ...