newbie :) help on lookup (or something)

[yas]

hello

ok here we go

im stuck on something heres what it is

ive got a data screen with
names ,
addresses,
tel,
customer ID,
and credit limit.

ive made a list using the Data --> Validation on another screen called the input screen.
but i want it so that when the name is clicked then the address, tell, ect automatically come in another cell

if not just the address by it self in another cell

sorry but i dont no if this is done before and i need it realli quick
i just feel like im banging my head on the wall lol

 

[NateO]

Howdy, and welcome to the board eh. You probably need a simple vlookup() eh:

From the help file:

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

=vlookup(drop down cell, table to look at, column offset to grab (to the right, 0 (exact match on unsorted data))

Bon chance.

 

[yas]

IT WORKED!!

THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[NateO]

Nice. You are welcome.

 

[yas]

sorry ive got another question

is there anyway i can delete the data in the cell without deleting the formula?

or if that is not possible how can i protect the formulas from accedental deleting?

 

[NateO]

sorry ive got another question

is there anyway i can delete the data in the cell without deleting the formula?

or if that is not possible how can i protect the formulas from accedental deleting?

That's 2.

1) Yes, but under what circumstances? You could use an if statement or conditional formatting...

2) Sure, protect the worksheet, make sure the cell's locked property is set to true under the format menu before protecting the sheet.

 

[Brian from Maui]

sorry ive got another question

is there anyway i can delete the data in the cell without deleting the formula?

or if that is not possible how can i protect the formulas from accedental deleting?

I don't see Nate around so...

Go to Format/Cells/Protection tab, tick locked/hidden, then go to Tools/Protection and protect the worksheet with or without a password.

Edit,

Oops sorry Nate....

 

[yas]

Thanks to Nate0 and Brian from Maui
i tried the locking of the cell and that worked

but is there another way with out the password protection to just hide the formula or something or is this the only way?

 

[NateO]

but is there another way with out the password protection to just hide the formula or something or is this the only way?

Well, a named range I suppose. You'd see something, but your intent would be opaque.

 

[yas]

how do u do that?
i just want to explore the options as much as possible

if any1 want to no im askin cuz im doing a project on spreadsheets and need abit of help with some stuff