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

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

On Mon, 3 Jul 2006 02:09:11 -0500, 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!

Obvious question, but why maintain four worksheets? If necessary, why
not just add an extra field for the continent in question and keep all
data on one sheet.

Then you could either use Data Filter to see relevant Costs and
Distances, or a Vlookup formula.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________