I would like to create a pricing program of sorts with numbers.
First, I want to create a source document listing all my product codes in the first column followed by four columns containing the list prices and relevant information.
Then I want to create a second spreadsheet that will look like an order form in which I can type in a product code (matching the source page identically) and have numbers automatically fill in the remaining columns from the source document onto the 'order form' page. Is there a way to get numbers to recognize a product code and fill in the corresponding info from a source document into another sheet?
I've been playing around with the LOOKUP and HLOOKUP function, but can't seem to get it figured out.
Spacing on the order form is set when you set up that form. If you want to match the spacing on the source document, then duplcate the source table, delete the data from the duplicate, and rpplace it with the formulas.
If you are transferring data from consecutive columns, you can replace the 2 and 4 in my two VLOOKUP formulas with COLUMN()-n. Adjust n to return the correct data from the first column to be transferred, then fill the formula right to pick up succeeding columns.
Here's a revised sample with the "Notes" column added and the VLOOKUP formula revised:
C2: =IFERROR(VLOOKUP($B,Data :: $A:$D,COLUMN()-1,FALSE),"")
Fill right to E2. Fill down to end of table.