Lookup Data from Group

muhammad susanto

Well-known Member
Joined
Jan 8, 2013
Messages
2,077
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
hi all..
i have table below, how to lookup with this condition (lookup in group)
Book1
FGHI
3Unit codeGROUPCLUE
4KP01HUMANGROUP1
5KP02FORESTRYGROUP1
6KW01ANIMALGROUP2
7KW01.1CATGROUP3
8KW01.2DOGGROUP3
9KW02ELECTRONICSGROUP2
10KW02.1GADGETGROUP3
11KW02.2MOBILE PHONEGROUP3
12KW02.3NOTEBOOKGROUP3
13
14expcted result (my target)
15GROUP1GROUP2GROUP3
16KP02FORESTRY
17KW02.2ELECTRONICSMOBILE PHONE
18KW01.2ANIMALDOG
19etc..
Sheet1


my target in cell G16 to I18

any help, thank in advance.

.sst
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
like this?

Unit codeGROUP1GROUP2GROUP3
KP01HUMAN
KP02FORESTRY
KW01ANIMAL
KW01.1CAT
KW01.2DOG
KW02ELECTRONICS
KW02.1GADGET
KW02.2MOBILE PHONE
KW02.3NOTEBOOK
 
Upvote 0
like this?

Unit codeGROUP1GROUP2GROUP3
KP01HUMAN
KP02FORESTRY
KW01ANIMAL
KW01.1CAT
KW01.2DOG
KW02ELECTRONICS
KW02.1GADGET
KW02.2MOBILE PHONE
KW02.3NOTEBOOK
thank, but not like that..
please, see my table above
for kw01.2, group 2 & group 3 must filled
 
Upvote 0
but ELECTRONICS is for KW02 not for KW02.2
could you explain the logic?
 
Upvote 0
Kw02 only in for Electronics, Kw02.01 (Gadget) in 2 group ( group2 and group3)

note :
i hope not use Pivot & Macro
 

Attachments

  • FOTO-LOOKUP.png
    FOTO-LOOKUP.png
    4.1 KB · Views: 4
Upvote 0
Kw02 only in for Electronics, Kw02.01 (Gadget) in 2 group ( group2 and group3)
I don't see GADGET in two groups
Unit codeGROUPCLUE
KP01HUMANGROUP1
KP02FORESTRYGROUP1
KW01ANIMALGROUP2
KW01.1CATGROUP3
KW01.2DOGGROUP3
KW02ELECTRONICSGROUP2
KW02.1GADGETGROUP3
KW02.2MOBILE PHONEGROUP3
KW02.3NOTEBOOKGROUP3


maybe you should define first level groups
 
Upvote 0
Unit codeGROUP1GROUP2GROUP3
KP02FORESTRY
KW01.1ANIMALCAT
KW01.2ANIMALDOG
KW02.1ELECTRONICSGADGET
KW02.2ELECTRONICSMOBILE PHONE
KW02.3ELECTRONICSNOTEBOOK

or post whole expected result from your example
 
Upvote 0
Unit codeGROUP1GROUP2GROUP3
KP02FORESTRY
KW01.1ANIMALCAT
KW01.2ANIMALDOG
KW02.1ELECTRONICSGADGET
KW02.2ELECTRONICSMOBILE PHONE
KW02.3ELECTRONICSNOTEBOOK

or post whole expected result from your example
Yea, that is i want it..
 
Upvote 0

Forum statistics

Threads
1,214,987
Messages
6,122,614
Members
449,091
Latest member
gaurav_7829

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top