hi Sean,

use the Vlookup function to achieve it

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Sean" escreveu:

I have a list of values in 3 columns (on Sheet), Revenue, Cost and
Profit each Relates to a Location

Locations are in ColA7:A75
Revenues are in ColC7:C75
Costs are in ColD7:D75
Profits are in ColE7:E75

What I wish to achieve is that when a user Selects a location (on
Sheet2), the appropriate values for Revenue, Cost and Profit relating
to the location selected will appear on Sheet2 in ColC, D and E

THanks for any help