Excel 2007 : Using the data in one spreadsheet to fill a column in another

[BluRay]

I need to fill the Tutor ID column in MODULES file ( picture Module&ID ) using the TUTORS file (picture Tutor ID). How to I do it without copy/paste?

[scottylad2]

=INDEX(TUTORS.xlsx!$A$2:$A$6,MATCH(B2,INDEX(TUTORS.xlsx!B$2:B$6&" "&TUTORS.xlsx!C$2:C$6,),0))

Hey BluRay,

try this formula in C2 in the Modules workbook It will work on a closed workbook should you only have 1 open

hope it helps

[scottylad2]

I saved these two after i'd posted the formula, hopefully when they reopen in the forum they will still have the correct syntax. Might need to re do but the formula i already posted you should be able to copy directly into your own copy

[BluRay]

Thanks scottylad2...