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? [closed]

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

FordGuy gravatar image

updated 2020-08-02 14:17:57 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-02 14:18:06.776479

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

Question Tools

1 follower


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

Seen: 234 times

Last updated: Mar 21 '16