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!
Red:(101,103,105)
Green:(102, 104,105)...