Forum Discussion
returning data from a dropdown option
Hi All, I am looking for some help with a spreadsheet that i am creating. I want to setup a dropdown option to select the relevant company and return the necessary data. This is what the ...
Hi mathetes
I thought that might be the case; designing the data to be flat I just didn't know if it was possible with the current layout.
With that being said do you have any advice on how to covert the data to a 'flat file' with the current format?
Also the data should look like this:
Thank you
For such layout
it could be in D12
=INDEX($C$4:$N$7,
MATCH($B12, $B$4:$B$7,0),
MATCH($C12,$C$2:$N$2,0)+COLUMN()-COLUMN($D$11)
)and drag it to the right and down.
If in such style I'd recommend not not to merge cells but use Center Across Selection
where the text is in most left cell.