Some excel help please

[B&W]

Hi, how do you make MS Excel automatically generate a set of values when you enter in another value.

I'll explain it in a simpler way

Let's say I have a Customer ID field on a sheet along with a address and name field.

What I need it to do is when I enter in a Customer ID in that sheet it should automatically generate that customers name and address to their respective fields in that sheet.

Which I am assuming requires some kind of database function in excel.

How would I go about doing this?

 

[wonder_lander]

Something like http://www.mission74.com/upload/OcUK.xls?

On the "Form" sheet enter the customer ID that matches one on the Customer ID's from the database sheet and it should prefil name, address and phone number into the form.

 

[suarve]

Hi, how do you make MS Excel automatically generate a set of values when you enter in another value.

I'll explain it in a simpler way

Let's say I have a Customer ID field on a sheet along with a address and name field.

What I need it to do is when I enter in a Customer ID in that sheet it should automatically generate that customers name and address to their respective fields in that sheet.

Which I am assuming requires some kind of database function in excel.

How would I go about doing this?

Would use some sort of vlookup tbh.