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!
Bookmarks