Hi,

I want to show table heading or title if detail matches approximately in another cell or group of cells. Is it possible in excel ?

Here is an example, table 2 shows if table 1 detail is there. If detail of two heading match both should be shown.

And if this case,

please help.

santosh

• Edited by drsantoshsinghrathore Monday, February 02, 2015 2:24 PM

it sounds like you need to combine some info. if so, you may use some code, like this:

Sub Merge_Specified_Cells()  

• Dim Cells As String  
• On Error GoTo ErrorHandler  
• Cells = InputBox("Enter the range of cells that you wish to merge." & vbNewLine & _  
•                   "For Example: To Enter a Range A1 to A3 type A1:A3 ")  
• If ActiveSheet.Range(Cells).Count > 1 Then  
•   ActiveSheet.Range(Cells).Merge  
•   MsgBox "Specified cells Merged!"  
• Else  
•   MsgBox "For Merging please enter a range containing At-Least 2 or More cells!", vbExclamation  
• End If  
• Exit Sub  
• ErrorHandler:  
• MsgBox "Entered Range is Invalid!", vbCritical  
• End Sub  

KR

Hi,

I am sorry, probably I could not ask properly. I have two cases, The first one, there is table 1. If I type green yellow in colour, sweet and flavoured, vitamin A, in column A then column B should show "mango". If I type pink red, has vitamin C then column B should show "apple".

In second,  if I type, green yellow in colour, sweet and flavoured, vitamin A, pink red, has vitamin C   in column A then column B should show"mango", "apple".

Means If there is an abstract from table 1 column A in table 2 column A, then column B in table 2 should show items from column B table 1.

Is it possible in excel ??

I will repeat it in other word again. If I have two descriptions with headings mango and apple. If I repeat few words from description of mango in column A, column B should show mango and same for apple. In another case, If I repeat description of mango and apple both in column A then column B should show both mango and apple at the same time.

regards

Yes, it's more clarity. I thinks it's possible and still needs some code, you need to create the rules that descripted.

KR