I have a LOOKUP table that has several rows of the same value but my lookup only returns the first result. Is there any way of returning the 2nd, 3rd etc result to the next columns?
Red 1
Blue 1
Green 1
Yellow 3
Orange 3
etc
Lookup value 1 only returns Red and 3 only returns Yellow. How can I get 1 to return Red in Column A, Blue in Column B and Green in Column C. Is there any 'simple' way of configuring so the LOOKUP reads number of entries and can place result in alternative columns?
Hope this makes sense to someone.
Thanks in anticipation of any answers.
Phil...
Red 1
Blue 1
Green 1
Yellow 3
Orange 3
etc
Lookup value 1 only returns Red and 3 only returns Yellow. How can I get 1 to return Red in Column A, Blue in Column B and Green in Column C. Is there any 'simple' way of configuring so the LOOKUP reads number of entries and can place result in alternative columns?
Hope this makes sense to someone.
Thanks in anticipation of any answers.
Phil...