CODEWITHSUNDEEP
google-sheets
Christian Vinther
Christian Vinther

Reputation: 11

When changing one value in cell, automatically fill out other cells

I would like to make a cell (B7) be able to automatically input value in cells B10:B12 based on the data from B2:D2 (that are put in manually)

Example: When putting in the ID 000100, B10:B12 should have the dates: 01-feb.2019, 10-feb.-2019, 12-feb.-2019

&

ID 000200 will then put in 01-mar.2019, 10-mar.-2019, 12-mar.-2019 in cell B10:B12

enter image description here

Upvotes: 0

Views: 33

Answers (2)

pnuts
pnuts

Reputation: 59485

Slightly shorter and should preserve the formatting:

=transpose(offset(A1,match(B7,A:A,0)-1,1,1,3))

Upvotes: 0

player0
player0

Reputation: 1

paste this in B10:

=ARRAYFORMULA(TRANSPOSE(VLOOKUP($B$7,A2:D5,{2,3,4},0)))

1

note: if you will get strange numbers like 43265 etc then you need to format B10:B12 as a date

EU syntax: =ARRAYFORMULA(TRANSPOSE(VLOOKUP($B$7;A2:D5;{2\3\4};0)))

Upvotes: 2

Related Questions