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


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=380138

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

worked like charm. thanks, thats so cool. :)


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=380138