Matching two sets of data

C

cjh1984

Hi all,

I have two spreadsheets and both spreadsheets contain a number o
projects. One contains the name and info about them and the othe
contains the costs for them. Each project is identified with a code
But in one spreadsheet the code is, for example, 000012.R. And i
another is 000012. I need to match up those codes within eac
spreadsheet and insert the correct cost against the respective projec
in the project info spreadsheet.

Can anybody tell me how to go about this or how to get started on it.
If you need more info just say!

Any help will greatly be appreciated!

Thank Yo
 
F

Frank Kabel

Hi
use VLOOKUP for this. e.g.
=VLOOKUP(A1 & ".R",'other_sheet'!$A$1:$B$100,2,0)
 
C

cjh1984

Thanks,

Also, is there anyway using a macro or vba that i can select, fo
example A1:F212, and copy it into a new workbook
 
Top