Need help in autofill from one worksheet to another

[_dave]

I need to keep a log of jobs I applied for (looking for work) for the state. I will apply for multi-positions at the same company as they are posted.

What I would like to do is to auto fill in the address of the company. Sheet1 is called “Applied” and sheet2 is “Co Address”.

My question is how can I do this? In the sample sheet I have C6 blank and I add a company to the “B” column then it is compared to a list of company names in sheet2 “CoAddress” and fill C6 with the address for me. This will save me time and not have any mistakes on the address. Can this even be done?

Enclosed is a file showing what I am trying to do.

Thanks ahead for any and all suggestions.

Fill In Cells.ods

[_dave]

M.A.,
Thanks, does just what I needed.

[mariosv]

You can do simple with a formula like: C6: =VLOOKUP(B6;$'Co Address'.$A:$B;2;0), search for the company in B6 through column ‘Co Address’.A returning value from column ‘Co Address’.B.