Apple Numbers

assuming your data is in the first four columns of a table named "Data"

and that the first column is the index (or lookup value). you can do what you want like this:

also assuming the columns will be in the same order...

enter the index or lookup value in column 1, then use this formula in the other columns. Select cell B1, then type (or copy and paste from here)

=VLOOKUP($A1, Data::$A:$E, COLUMN(), 0)

shorthand is:

B1=VLOOKUP($A1, Data::$A:$E, COLUMN(), 0)

select cell B1, copy

select cell B1 thru E1, paste

Hi Alan,

"Is there a way I can populate only the cells I need to order from the data sheet? "

That's essentially what Wayne's solution does.

In the Data table, column A contains the Item Number assigned to each specific item.

Columns B, C and D contain the item name, and other data about the item (could be size, colour, price).

Table 1-1 is one line of the table on your order form,

The formula shown is entered in cell B1, then filled right into C1 and D1.

You can add as many rows as needed to that table, and fill the three copies of the formula down to the last row.

To use the form:

Enter an item number in cell A1

Enter different item number in A2, and a third item number in A3.

Each row will be populated by the three data items associated with ('on the same row of the Data table as) the item number entered in column A.

You can get a more detailed description of the VLOOKUP function in the Function Browser. To open the browser, click on any cell in a table (choose an empty cell), then type =

The Formula editor will open (at the cell), and can be moved by clicking it to the left of the ƒ symbol and dragging the editor to a new location.

The Function Browser will open in the right sidebar.

Functions are listed alphabetically in the browser, and are also grouped in categories by type, listed in the browser's left column, Typing in the search box automatically shortens the list to show only functions whose name contains the series of letters currently in the box. For VLOOKUP, 'VL' or 'OO' or 'OK' should shorten the list to the point where you can click on VLOOKUP to see the description and other details regarding this function.

Regards,

Barry