Find and match funtion
I have this in my
worksheet 1 worksheet 2 worksheet 3
column A column A column B
Civil Isometrics Turbines
Mechanical Vendors Electrical
Electrical Scope Waste Managemet
Instrument Electrical QMS
.......ans so on
I want to find the word "Electrical" from my 3worksheets and the results
will appear next to the cell of worksheet 1 column A which is column B and C,
like this
w o r k s h e e t 1
column A column B column C
Civil
Mechanical
Electrical Electrical Electrical
Instrument
thanks
"Shane Devenshire" wrote:
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
|