Hello everyone and happy friday,

apologize in advance for confusing title.

i'm going to try to explain to the best of my knowledge.

in column A is a value and column B & C & D has a lookup formula to lookup the value in A.

for example, the value in row 1 might say 1111. so in another tab value 1111 is displayed 3 times, but all have a different value in the column over.

so i would like B to display one of the differences, and C and D and so fourth.

i don't want B-D to display the same lookup value.

if this makes no sense or is too confusing please let me know and i will try and explain further.

Thank you in advance,
Bryan N.