Working with excel sheets

[I want to learn more]

I know that excel is mostly about formulas. But I do think that this problem
can be resolved using excel and the extra spreadsheets.
I have on spread sheet 1 customers name: and address: cells. I have my
customers on a drop down cell. So automatically I can pick out of a list of
people I put on sheet 2. But I also want the cell in the address line to
automatically change address everytime I change the name on my customer. Is
there a possibility that I can use sheet 2 for customers and address and then
put them in two different cells on sheet 1.

 

[smartin]

I know that excel is mostly about formulas. But I do think that this problem
can be resolved using excel and the extra spreadsheets.
I have on spread sheet 1 customers name: and address: cells. I have my
customers on a drop down cell. So automatically I can pick out of a list of
people I put on sheet 2. But I also want the cell in the address line to
automatically change address everytime I change the name on my customer. Is
there a possibility that I can use sheet 2 for customers and address and then
put them in two different cells on sheet 1.

I think you should look at how to use the VLOOKUP function. If one of
your sheets has name and address information that will remain static, in
another sheet you can use VLOOKUP to obtain the address information
based on the name. The basic formula might look like this:

=VLOOKUP($A1, '[Static sheet name]'!$A$1:$B$1000, 2, false)

In my example, I assume your static information is in columns A (name)
and B (address). You would need to replace the sheet name appropriately,
or better still, use the VLOOKUP wizard.