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
Question marked as
Top-ranking reply
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