Accestimator wrote:
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.

Hi,

I think that VLOOKUP should suite for you. Check the online help for the
function.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy