Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and match funtion
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find and match funtion
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find funtion in macro | Excel Discussion (Misc queries) | |||
create a report and have a search funtion to find data | Excel Discussion (Misc queries) | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
How do I find age in years from anniversary date (Age funtion)? | Excel Worksheet Functions | |||
Excel funtion to find how many boxes in larger container | Excel Worksheet Functions |