I need a cell to take a number I input between 1 and 25.
On the basis of that input, another cell must lookup what that number represents from a list elsewhere.
So for example, I input "20" into cell A1.
Cell A2 must then display "57,000" where it makes reference to a predetermined static list of 1-25 equaling specific numbers. Ideally, this is on a second sheet, unseen by the user.
Is that possible in Apple Numbers?
MacBook Pro 15", macOS 10.14
yes.
create a table that contains the translation:
make the first row a header row. I made up entries in the column B except for the entry on 20 which you already shared should result in 57000
Make sure to name the table "Trans" (name is not important bu I was using this to mean "translation"
then in a separate table:
enter the value in column A
then in cell B2 enter the formula:
=VLOOKUP(A2, Trans::A:B, 2, 0)
yes.
create a table that contains the translation:
make the first row a header row. I made up entries in the column B except for the entry on 20 which you already shared should result in 57000
Make sure to name the table "Trans" (name is not important bu I was using this to mean "translation"
then in a separate table:
enter the value in column A
then in cell B2 enter the formula:
=VLOOKUP(A2, Trans::A:B, 2, 0)
Thanks so much Wayne! I got it working eventually. Realized that I had to have column header names to make the reference work.
Numbers - formula to pick data
