Newbee in Exell needs HELP, thx !

[ddsends]

Hi,

I'm a newbee in the use of Exell and have a problem.

I need to do the following;

Create an Exell worksheet with various fields to fill automaticly when I put an Client N° into one field it must automaticlye put the rest of the info into the fields, example;

Client N°
Name
adress
phone N°
and so on ......

So if I put the client N° into the Client N° field it must auto fill the other fields with the correct info off that client.

How Do I DO This ???????

Thx to al responders. Regards from,
DDSend.

 

[AngO]

Assuming that you have the information you want it to fill in stored somewhere - You need to use the vlookup or hlookup function. v=vertical; The information is stored in vertical columns (most common). h=horizontal; the information is stored in rows.

=vlookup(lookup_value,table_array,col_index_num,range_lookup)

lookup_value=the cell you put in the N

table_array=the data list where the information is stored (do not select the header row)

col_index_num=the column number where the answer is located in the data list. In this example the following are column headings: Company, Address, etc. If I want it to return the address when I type in the name, the column index number is 2 (the second column in the data list contains the answer.

range_lookup=True or False
True=finds the nearest value, and returns the one preceding it.
False=finds exact values, if the lookup value is not found in the data list it returns a N/A error.

Best wishes,
AngO