Numbers version of Data Validation?
In Excel I have created a "Food&values" table of data consisting of foods types and their nutritional values per serving.
On a separate sheet "Foods" using Data Validation I am able to pull data from column B of "Food&values" with only partial typing of text.
Note: Excel Data Validation allows me to make edits directly to the contents of "Food&values" without rewriting/recreating "Foods" column B. I attempted to use "Pop-Up" list in Numbers and was unable to edit master list without recreating the list.
After entering the serving amount in the column "C" I use the following formula =IFERROR(PRODUCT(C2*(VLOOKUP(B2,'Food&values'!$B$2:$E$50,2,FALSE))),"") to have the calculated values entered from "Food&values".
All this was completed several years ago. I have no formal training and used many, many google searches.
I am not have any success with switching this over to Numbers. I feel like I'm not asking the correct questions.
Any and all help is appreciated.
Thank you.
[Edited by Moderator]
iMac 24″