Put in C2:

=INDEX(INDIRECT("'"&C$1&"'!C:C"),MATCH(Master!$B2, INDIRECT("'"&C$1&"'!B:B"),
0))

The suggested formula above is okay, but it inadvertently carried
an extraneous sheet reference (Master!) in: Master!$B2
(sorry about that)

Put instead in C2:
=INDEX(INDIRECT("'"&C$1&"'!C:C"),MATCH($B2,INDIREC T("'"&C$1&"'!B:B"),0))

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--