How do I extract data from 4 other worksheets to input into one other
worksheet?

e.g. I have Costs and Distance for 4 different Destinations on 4
worksheets respectively. When I type in a Destination (say, Singapore)
on a new sheet, I want the Cost and Distance to appear automatically.
Different destinations will have different costs and distances. The
destinations are in 4 different worksheets, grouped according to
continents, together with their respective Costs and Distances.

I need help in having the correct formulas that will cause the
automatic appearance of Cost and Distance when I type in a Destination.


Thanks!


--
peiwen
------------------------------------------------------------------------
peiwen's Profile: http://www.excelforum.com/member.php...o&userid=35989
View this thread: http://www.excelforum.com/showthread...hreadid=557763