How do I make specific variables equal to different specific variables

[Cbn]

How do I make it so that when I place a different numbers in one Colume/roe (ie. B7) it equals a different specific numbers in C7.

An example of this would be I want a list of numbers 5,4,2,7,53 to equal a different list of numbers in a different colume. so 53 in b7 = 14 in c7 or 4 in b7 equals a 8 in c7 or a 2 in b7 equals 12 in c7. But the full list is available for the specific box.

I know very little about spreadsheets. I created the array (created sheet 2) It has 12 columns with two rows… If I on page one type a 12 it should look up 12a from sheet 2 and in response put the number from 12b.
I do not know how to use the formula =VLOOKUP(B7;Sheet2.A1:B6;2;0), I do now know what the order means or what the punctuation does. What does the (B7) mean, what does ( mean, I believe Sheet2 (refers to sheet 2) and what does (.), (A1), (:), (B6), (;), (2), (;), (0), all mean.

Thank you,
Cbn

[Regina]

You can write an array of the corresponding values to another sheet, for example to Sheet2.A1:B6. Use Data > Validity in B7 with type ‘cell range’ and enter the range $Sheet2.$A$1:$A$6. Cell C7 gets its value using the formula=VLOOKUP(B7;Sheet2.A1:B6;2;0). The third parameter tells, that the return value is column 2 of the range, and the forth parameter 0 means, that the values in the range are not sorted.

Instead of validity you can use a form control “List box” as well, which is linked to B7. Or you let enter the value manually, but then it might be, that the entry has no corresponding value.

[Cbn]

Could you elaborate, I know very little about spreadsheets. I created the array (created sheet 2) It has 12 columns with two rows… If I on page one type a 12 it should look up 12a from sheet 2 and in response put the number from 12b.
I do not know how to use the formula you gave, I do now know what the order means or what the punctuation does. =VLOOKUP(B7;Sheet2.A1:B6;2;0)What does the (B7) mean, what does ( mean, I believe Sheet2 (refers to sheet 2) and what does (.), (A1), (:), (B6), (;),

[Regina]

V in VLOOKUP means “vertical”. You have to write the list in 2 columns and 12 rows.

; is the separator between function arguments, . is the separator between sheet name and cell address, : is used inside a range address. Set the delimiter you like in Tools > Options > Calc > Formula.

For the other questions you should look for a beginners tutorial. It need not to be written for LibreOffice, but any other spreadsheet application will do. The basics are the same

[Cbn]

Ok if anyone else has this trouble with this I am going to do a breakdown of what Regina said “now that I know” with my formula

I created my Sheet two (insert sheet 2) and made two columns with 12 rows When this area is selected it’s formula is A1:B12. “sheet 2 is not needed but it keeps the material off of my main page”

So the formula that I put in the column I want to display my number is =VLOOKUP(E2,A1:B12,2,1)

E2 (is the row that it is looking at to get the number)
A2:B12 (is so it looks at everything from A2-12 and B2-12)
2 (is so it gives me the number from the second row selected which is B)
and
1 (is the mode ( I don’t know what different modes do or why it matters but 1 is ascending order) ).