MacMost Now 762: Using the Lookup Function In Numbers

The Lookup function can be useful if you want to automatically populate cells on one table with data from another, based on new data entered. For instance, you can enter products in one column and then have prices fill in automatically by having the Lookup function refer to a list of products and prices in a second table.

Comments: 6 Responses to “MacMost Now 762: Using the Lookup Function In Numbers”

    Scott Pesetsky
    7 years ago

    Thanks for this video.

    Question 1: Can the lookup function look to other documents?

    Question 2: Does this also work in Pages?

    I am seeking a good document automation solution.

    Scott

      7 years ago

      I don’t think it can look in other document. But try it. Maybe.
      Now, I don’t think this would work in Pages — but also, try it. You have the same functions there.

    Sunny
    7 years ago

    Is there a way to populate the Pop-Up Menu from a List rather than typing in the values?
    Sunny.

    Nilesh Parmar
    7 years ago

    Wow great tut. Amazing what numbers can do. Can you do a video on how to transpose in numbers please?

Comments Closed.