Hi,

I'm not clear on the question. Why not show some dummy data and what you
want to see based on that data layout.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Denver" wrote:

Hi,

I have a spreadsheet-excel 2003 i have 3 worksheet on it
namely vendors, discipline and pakcage

I want to find a certain text like Civil and Mechanical the same on the
other 2 worksheet (woksheet 2 and 3)
I need the result to appear next beside on its cell on worksheet 1
like for instance cell A1 = Civil
so the result would be next to it B1 - Civil


how would I write my formula?

thanks, I appreciate any help