Match Formula

[Naveenaggarwal]

Hi,

I am having some data in A Column and Defined group name in F & G Column.

I want C column to be updated automatically with the related group.

But few units are in both the groups which can be corrected(duplicate can be deleted)

enclosing sheet for reference.

It may be easy but still Please support.

[rcm]

insert the following in c2 and copy down

Please Login or Register  to view this content.

[FlameRetired]

Another way.

Please Login or Register  to view this content.

[FlameRetired]

Since data in F:G is sorted ascending you can use approximate match.

Please Login or Register  to view this content.

[Phuocam]

Or:

=IF(COUNTIF(Group_A,A2),"Group A",IF(COUNTIF(Group_B,A2),"Group B",""))

[leelnich]

In C2 and copy down (assuming E1 = ""):

Please Login or Register  to view this content.