This should do the trick for you. This would be for the first automatic
column, for the second, just change the '2' at the end of the index
functions to a '3'.

=IF($A2=1,INDEX(English!$A:$C,MATCH($B2,English!$A :$A,0),2),INDEX(Metric!$A:$C,MATCH($B2,Metric!$A:$ A,0),2))

Let me know if you have questions - Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=380138