Insert in empty cells values from the same sheet

Question

I need to seach in an column if there are similar id's and if yes ro copy the group and insert in the empty cell.

I have the following table

Group  Status  ID
       Log in   1
       Log out  1
       Log in   3
       Log out  2
A               1
B               2
C               3

The table should look like this:

Group  Status  ID
A      Log in   1
A      Log out  1
C      Log in   3
B      Log out  2
A               1
B               2
C               3

To do this I tried to use this formula:

=IF(C2=(C4:C7);(A4:A7);IF(C2=(C4:C7);(A4:A7);""))

Unfortunatly it is not working, any idea why?

Do your groups correspond to IDs? I.E. A = 1, B = 2, C = 3 etc...? — urdearboy
– urdearboy, Commented Feb 18, 2019 at 15:37
The range. From C4 to C7. I want to check if C2 is equal with a value from this range — Catalin Vasilescu
– Catalin Vasilescu, Commented Feb 18, 2019 at 15:38
Yes, the groups correspound to ID's, but i need to find them and insert in the empy cells — Catalin Vasilescu
– Catalin Vasilescu, Commented Feb 18, 2019 at 15:39

Nathan_Sav · Accepted Answer · 2019-02-18 15:49:24Z

1

not sure if I get what you mean, but I'd try something like this

=INDEX($C$6:$C$8,MATCH(E2,$E$6:$E$8,0),1)

answered Feb 18, 2019 at 15:49

Nathan_Sav

8,5762 gold badges18 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Something like this. Thanks for the idea.

urdearboy · Accepted Answer · 2019-02-18 16:05:29Z

0

Create a table that matches your IDs to Groups (table on right). This can be housed on a hidden sheet and updated in future as needed (which will be much easier to manage in comparison to updating tedious nested IF statements formulas)
Insert VLOOKUP on your main table
Drag formula down to end of range

In the formula, Table1 is the name of the right table that houses your matching Groups

result

formulas used

answered Feb 18, 2019 at 15:47

urdearboy

14.6k6 gold badges35 silver badges64 bronze badges

Thanks for the idea!