Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,174
- Office Version
- 365
- 2019
- Platform
- Windows
Good afternoon,
I have data in A1:A5 that looks like this (just a sample). In B1 let’s say I would house 101 and in C1 I would like to return Red. One caveat is that if I lookup 102 then I would like to return Green, Blue. Thanks in advance!
I have data in A1:A5 that looks like this (just a sample). In B1 let’s say I would house 101 and in C1 I would like to return Red. One caveat is that if I lookup 102 then I would like to return Green, Blue. Thanks in advance!
Code:
Red:(101,103,105)
Green:(102, 104,105)
Black:(104,111,115,117,119)
Blue:(102,162,169)
Last edited: