automatic information fill

so i have a table http://yfrog.com/1614329992p
it is possible to type the 4-digit code in the yellow cell and the info of green cells fill automati

Yes, with a table of all your info with your 4 digit code in the first column, use VLOOKUP to pull the rest of the information.

mazviux,

welcome to the forum. If you want to illustrate your issue with a file, please upload it with the forum tools. Do not use links to external, untrusted sites.

For one, we have no way of knowing how big your file is, before we can decide to download it.
Secondly, many file sharing sites are blocked by company firewalls, reducing the number of people who can help you.

Step 1. Create a table with all your information. Let's say this is on Sheet 2. Column A would be your 4 digit code, then other columns with for each of your green rows (I'm not even going to try translating ).

Step 2. on your first sheet in B2
=IF(ISNUMBER(E2),VLOOKUP(E2,'Sheet 2'!$A$2:$E$150,2,FALSE),"")

where
ISNUMBER(E2) checks to see if there's a number in E2 before doing the VLOOKUP
'Sheet 2'!$A$2:$E$150 is where your data is on sheet 2. Adjust this to fit your actual data. The $ signs keep the range from moving when you copy and paste or drag your formula.
2 is what column (on Sheet 2) the particular data you are looking for is in.
FALSE means return only exact matches.

Hope that helped. As Teylyn stated, it's easier if you can upload an example spreadsheet to this forum (Go Advanced > Manage attachments).

Okay, in order to use the VLOOKUP, you need to have your 4 digit code be the first column in your table (I moved it in my example).

I used defined name to name your table "Table" just to make things easier.

An explaination of defined names:
http://www.contextures.com/xlNames01.html

I also put numbers at the bottom of your table so it would be easy to see what column you want to lookup. Normally, the first column of data is 1, next set 2, and so on but because you merged cells, it's necessary to actually count the columns. So the 3rd set of data would be column 5.

I filled in the VLOOKUPS for your first two columns of data. ie. in C9

=VLOOKUP(E9,Table,2,FALSE)

I didn't fill in the last few columns because the values you currently have in there for 1106 don't match any of the values in your table for 1106 and I wasn't sure what column you wanted to pull. You should be able to figure it out from here though.