Ask Your Question

How do I make on cell equal another if a certain word is entered into it, also I need other cell to equal certain things after the word is typed?

asked 2016-03-21 03:08:56 +0200

FordGuy gravatar image

I'm at a loss here, I need help.

What I'm trying to do is have a list on one sheet with names say in a column like A1 to A25 and then another set of cells with additional info in Like B1 to B25. Now what I'm trying to do is have another sheet That I can just type the name in and when a name is typed in a certain cell it will send the info to another sheet with the info in a cell and the additional info in the cell next to it.

I know it's hard to explain but this would be the break down: A list of names in cell A1, additional info in cell B1 on sheet 1. Sheet 2 would contain different cells but say when I enter a name in cell F6 on Sheet 2. Sheet 3 A1 would show the name and B2 would show additional info, but if I change the name on sheet 2 in cell F6, it would automatically change the info on sheet 3.

I know if someone can point me in the right direction, I can figure out the rest of which I have to do. Thanks for any help someone can give me.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-03-21 09:35:01 +0200

JohnSUN gravatar image

Do you mean something like this - DataOnSheet3FromSheet1BySheet2.ods?

edit flag offensive delete link more


Just got done, editing my sheets. It worked like a charm. Thank you very much.

FordGuy gravatar imageFordGuy ( 2016-03-21 23:38:57 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-03-21 03:08:56 +0200

Seen: 230 times

Last updated: Mar 21 '16