How to move text from one spreadsheet to another using formulas

Question

Level 1

8 points

How to move text from one spreadsheet to another using formulas

Please help, I am not very good with formulas in Numbers.

In Numbers version 10.3, I would like to be able to enter a 4 digit number in a cell in column E (for example E7) in sheet 1. The formula would then compare this number to the numbers in sheet 2 column A. When it finds that number in sheet 2 (for example in A24), the formula will take the text in the sheet 2 cells B24 to E24 and copy them into sheet 1 cells A7 to D7 (for this example).

Sheet 1 will be a sign in sheet. Entering the 4 digit number will be far faster than entering the name, address etc for each person every time. That information will be stored on sheet 2.

Posted on Sep 23, 2020 1:00 PM

Reply

Answer 1

Badunit

Level 7

28,192 points

Sep 23, 2020 4:04 PM in response to vanott

The latest version of Numbers as of this moment on OS X is 10.2.

Numbers has Sheets, which are like a blank canvas, and Tables that have columns and rows of Cells. By "Sheet 1" and "Sheet 2" I am assuming you are referring to "Table 1 on Sheet 1" and "Table 1 on Sheet 2"

Formula for Sheet 1::Table 1::B7 =XLOOKUP($E7,Sheet 2::Table 1::$A,Sheet 2::Table 1::B, "Not Found")

Fill right to complete C7 and E7

Reply