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