L
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 tw
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 <---- automati
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 tw
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 <---- automati