I am using Excel and I need a function that look up a valule in column A and
returns the Text value from B, C, and D.

Here is what I am doing I got 8 sheets with people's names and in column A
on each of these sheets I have a value let say 1J, 2J, 3J, etc to 20J this
would be the same on all 8 sheets. Now on sheet 9 I have a list of 1000
items and in column A i want to put 1J, 2P, 1T, ect.. for the 8 sheets. Then
I want it to return the text strings in Column B, C, and D.

It will not be in acending or decending orders.

Thanks for the help.