On Sheet 2, I have scenarios in A1, B1, C1 etc. and relevant information in A2-A4, B2-B3, C2-C5 etc.
I would like to use A1 in Sheet 1 for a dropdown list of the first column of Sheet 2, and have the B row in Sheet 1 bring up the relevant information of the corresponding row.
I have only recently began experimenting with LibreOffice, and I believe I’ll manage to sort out the dropdown list issue, but I would like to confirm if there is a way to pull information like that.