automatic output from known data

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
 
C

cvolkert

This should do the trick for you. This would be for the first automati
column, for the second, just change the '2' at the end of the inde
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 - Cha
 
Top