Pull Data from one table to another

**cjest2002** · 03-13-2013, 05:39 PM

Good afternoon.

I have tried searching for the answer before i post, and have tried various things to do this in my own spreadsheet, but it seems i am missing something. So i created a simple representation of the spreadsheet to facilitate what i need.

The main table is the user inputed information. It is dynamic in that the user will be adding more rows as time goes on. The other tables are going to be generated on their own via equations (i am not interested in using macros) and pulling the information from the first table. Each table (not including the first) pulls the information from the first tabel dependant an one item. It will hold all the original inputs and allow for more to be added later.

Again, this is in the example with how the information would look, equations withstanding.

If someone could help me out, it would be greatly appreciated.

**profector** · 03-13-2013, 06:03 PM

You could copy/link the data to different worksheets (one for each group, A,B,C) then filter them by item.

But really I would suggest Microsoft Access. The main table holds the data. Then A,B, and C would be a query in a simple report.

**cjest2002** · 03-13-2013, 06:22 PM

This data that i presented is only the middle of the spreadsheet. A lot of information and calculations are done before and after what i presented. Thus the format.

The tables that have the specific item have considerably more info that is pulled in then the 3 columns of info i have provided. But that info can be brought in through index queries.

I am just trying to get an idea as to how to bring in the initial data entry withouth having duplicates and bringing in new data entries when they are entered.

**Harribone** · 03-13-2013, 06:05 PM

In cell F4:

=IFERROR(VLOOKUP($E4,$A:$C,2,FALSE),"")

In cell G4

=IFERROR(VLOOKUP($E4,$A:$C,3,FALSE),"")

Then copy down. This will do the job for you.

The IFERROR bit just leaves the cell blank if the input cell is blank or data isn't found in the original table. VLOOKUP is the bit that finds the data from your table.
The first bit is the cell which contains the data to look for (E4), the second bit is the location of the data (A:C - note the whole column is referenced so that extra rows added later on will be included in the search), the third bit is the column number of the original table which contains the value to return and FALSE means this must be an exact match.

I recommend you search fro more info on VLOOKUPs to help give you a better understanding of this formula.

**profector** · 03-14-2013, 09:43 AM

The vlookup by itself won't help much in this case becuase of the setup. You could try something like and "index" and "match". When you combine them you can get a "vlookup with multiple criteria". But really you're going to have a lot of steps to get it right.

**cjest2002** · 03-15-2013, 07:53 PM

I have solved the problem with two helper columns. Using countif and vlookup.

Please see attached file for the solution. And this can be used for many other things as well.