brnielsen44
New member
- Joined
- Aug 29, 2014
- Messages
- 2
- Reaction score
- 0
- Points
- 0
I understand how to use a asterisk in a VLOOKUP function's "lookup_value" but I need to work it a little backwards and use a wild card in the "table_array" somehow.
Example:
Cell A1
c.b.a
Cells C1 : C3
a.*.*
b.*.*
c.a.*
c.*.a
Cells D1 : D3
Group 1
Group 2
Group 3
Group 4
I need Cell B1 to vlookup what's in A1 ("c.b.a") and return Group 4.
I have about a thousand values in column A that need to each be assigned one of 50 groups (all in column D). Is there a way to use the wildcard in this backwards function?
Thanks,
brnielsen44
Example:
Cell A1
c.b.a
Cells C1 : C3
a.*.*
b.*.*
c.a.*
c.*.a
Cells D1 : D3
Group 1
Group 2
Group 3
Group 4
I need Cell B1 to vlookup what's in A1 ("c.b.a") and return Group 4.
I have about a thousand values in column A that need to each be assigned one of 50 groups (all in column D). Is there a way to use the wildcard in this backwards function?
Thanks,
brnielsen44