How can I make a single selection drop down auto fill a ton of other cells?
I've not used excel much so I'm in way over my head. I've watched a bunch of videos and can get one cell to fill from a drop down but it seems to only work if they're 'lined up' with each other? For example in the 1st picture below, the drop down I have I can get 5 and 10-year to autofill MSUP 1st and 2nd Coats respectively, but only if they're next to each other as shown. I may not be explaining this well, sorry in advance if I am, I pretty much just want to select one product / warranty and have it auto fill all the green. I have templates on another sheet posted below that I've been copying and pasting when I price out jobs but it's just not efficient at all.
I suspect that I have to organise or format my 'templates' somehow in order to make the V or X lookup function reference it? Either way, I'm pretty lost, so any help is appreciated, thanks guys!!~\~
EDIT: ok I've managed to get the drop down list to populate the correct items for 1 product by 'tagging' but this is reliant on putting this formula in each of these highlighted cells. My problem now is these cells are 'locked' looking for data from the same area as this 1 product, but I need it to search the entire sheet. When I select the entire sheet for the 'return array' it gives a value error presumably because it's trying to pull more than 1 value and put it in a single cell from my 'tags'. I suppose I could make a sheet for each system template we have but that would be cumbersome to work on. Is there a better way to do this? Am I even making sense? haha
=XLOOKUP($B$7,Sheet1!A20,Sheet1!B20)
[link] [comments]
Want to read more?
Check out the full article on the original site