sorting columns from different workbooks

  • Thread starter Thread starter Gaurab
  • Start date Start date
G

Gaurab

Hi,
I have two workbooks. The first has 6 cols, the 6th col is an index
col with characters from A0101 to P2425, there are no repeats.
The 2nd workbook has 2 cols, there is an index col and a data column.
The index colum has a subset of the index in the first workbook.

I would like to create a 3rd workbook/sheet which amlagates the first
2 workbooks and create a single index col which has the data col while
also having all cols in the first workbook.

I am relatively new to using excel and thanks for the advice.

Gaurab
 
Since the second worksheet has a subset of indices from the first, you could use
=vlookup() to return that second column from worksheet B.

Something like:
=vlookup(f1,sheet2!$a:$b,2,false)
in an unused column (G???).

You'll get #n/a's returned if it doesn't find a match. You can hide those
errors with something like:

=if(iserror(vlookup(f1,sheet2!$a:$b,2,false)),"missing",
vlookup(f1,sheet2!$a:$b,2,false))

(replace "missing" with what ever you want, including "").
 
Back
Top