Apple numbers
Does anyone know how to make a drop down menu auto fill other cells. Ie if cell A1 = David A4-A6 would automatically fill in contact info for that person
Ty
iMac 27″, macOS 10.12
Apple Intelligence is now available on iPhone, iPad, and Mac!
Does anyone know how to make a drop down menu auto fill other cells. Ie if cell A1 = David A4-A6 would automatically fill in contact info for that person
Ty
iMac 27″, macOS 10.12
In general it sounds as if you need to do what's called a "lookup." Based on what you enter in A1 you look up the information for A4:A6 from another table. One way is to use the XLOOKUP function, something like this:
Formula in A4: =XLOOKUP(A$1,Info::$A,Info::B,"Not found")
Formula in A5: =XLOOKUP(A$1,Info::$A,Info::C,"Not found")
Formula in A6: =XLOOKUP(A$1,Info::$A,Info::D,"Not found")
Substitute ; for , in the formulas if your regions uses , as a decimal separator.
More on XLOOKUP here.
SG
In general it sounds as if you need to do what's called a "lookup." Based on what you enter in A1 you look up the information for A4:A6 from another table. One way is to use the XLOOKUP function, something like this:
Formula in A4: =XLOOKUP(A$1,Info::$A,Info::B,"Not found")
Formula in A5: =XLOOKUP(A$1,Info::$A,Info::C,"Not found")
Formula in A6: =XLOOKUP(A$1,Info::$A,Info::D,"Not found")
Substitute ; for , in the formulas if your regions uses , as a decimal separator.
More on XLOOKUP here.
SG
Maybe you can help me with another Salutions
example
if B4 is a drop down menu with a list of steaks
and B5 is a quantity
and B6 is a total weight
how can I select a steak from the drop down then type a quantity in the B5 cell and have it populate a total weight in B6
Thank you very helpful
Apple numbers