Matching ab cd columns and get e column data

[satish78]

Hi Friends,

I been trying to match 4 columns like AB with CD to get E Column data into F column but could not able to get there.
Here is sample sheet which I am trying to match.


Hope you understand what I am looking for.

Thanks
Kumar

 

[AliGW]

I have no idea what is required now - sorry. Where is that example match data bottom right of the post meant to appear? Can you not explain the logic of the matches in words? You are leaving an awful lot for us to try to work out for ourselves. Does your sample dataset need to be so big? It just needs to be big enough to encompass all eventualities.

 

[satish78]

A with C and b with D

 

[satish78]

I included sample matched emails in columnF (only 2 emails for example). Please see below the matched data with (I could have upload a video but cannot here, do not know how)

 

[satish78]

Here is the detailed one:

Please copy paste that big list into excel sheet. so that, it will be easy to explain.
I included sample matched email in columnF (only email for example below). Please see below the matched data.

 

[satish78]

Here is the formula which is close to what I am looking for (got it at stackoverflow)
<code>=IF(INDEX(A:D,MATCH(C2,A:A),2)=D2,"Yes","No") modified to IF(INDEX(A:D,MATCH(C1,A:A),2)=D1,E1)<code> </code>get ColumnE data but it does not do partial match ColumnD text in ColumnB and also it not get ColumnE data to right row. Mean if C2 and D2 data is matched with A5 and B5 then get E2 data to E5.</code>

 

[oldbrewer]

I am still unclear what you are trying to do so make up 3 rows of pretend data and tell us eg

name1.......job1........name2..........job2..........name2@email.com

are you looking for name1 anywhere in third column and putting email address in column 5 against name1 in first column ???

 

[satish78]

yes, exactly

I am looking for name2 job2 anywhere in first column and 2nd column putting email address in column 5 against name1 job1 in first column ???

 

[AliGW]

yes, exactly

I am looking for name2 job2 anywhere in first column and 2nd column putting email address in column 5 against name1 job1 in first column ???

Eh??? Say that again ... S-L-O-W-L-Y!

This needs illustrating properly: please provide some sample data, but make sure that it is in proper tabular format (what you have provided previously has been all over the place, adding to the confusion). You could use the ForumTools add-in for this (link in my sig line).

 

[oldbrewer]

I cannot help further - you are not helping us to help you...sorry