Adding value on the next column based on the Pop Up Menu in Numbers

Hi hanseno,

I would use XLOOKUP for this task.

Formula for B2=XLOOKUP(A2,Pricelist::A,Pricelist::B,"NF",0,1)

XLOOKUP will take the name from cell A2 and search for this in column A of your pricelist if it is in the list it will return the price that is listed in column B of your pricelist. If the fruit is not in the pricelist it will write "NF" in your table. You can replace the NF with everything, I use NF for Not Found.

It must find an exact match and goes from first to last entry in your pricelist.

XLOOKUP - Apple Support

Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.

Hope this will solve your question, please let me know if this worked for you or if something in unclear.

Regards Ralf

You can try something like this:

I made a Pop-up menu for column A of Table 1 by selecting cells in that column and choosing Pop-Up Menu as Data Format. When I did that the Pop-Up Menu choices for each cell were populated automatically with Apples, Oranges, etc. (rather than having to input the menu choices in each cell).

The formula in B2, filled down, is:

=XLOOKUP(A2,Pricelist::A,Pricelist::B,0)

Or, if your regions uses , as a decimal separator the formula would be this instead:

=XLOOKUP(A2;Pricelist::A;Pricelist::B;0)

The 0 is what the formula displays if it can't find a match in the Pricelist table. You can change that to "" or "can't find" or whatever you want.

SG