automatic output from known data

[lsu-i-like]

i have 2 spreadsheets of data: 1=english, 2=metric
each spreadsheet has 3 columns, with the first column being an ID #.

on my output spreadsheet i have 4 blanks.
in blank 1 i enter a "1" or "2" for english/metric
in blank 2 i enter the ID #
i want blanks 3 and 4 to automatically be filled with the other two numbers from the id#'s row.

DATA WORKSHEETS
english
1 123.8 9.8
2 122.7 10.3
...

metric
1 1983 9.8
2 1965 10.3
...

OUTPUT WORKSHEET
blank 1 = english <----- manual
blank 2 = 1 <----- manual
blank 3 = 123.8 <---- automatic
blank 4 = 9.8 <---- automatic

[cvolkert]

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

[lsu-i-like]

worked like charm. thanks, thats so cool.