peiwen wrote:
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!

I think you could use VLOOKUP function. You can check the on line help. If
you need some more help, please post back here, posting your formula and
some example data, or if you like you can upload an example file on
www.savefile.com.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy