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