You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
