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

 

[oldbrewer]

I never download or open links. Show us 10 rows of data with desired outcome.

 

[satish78]

Here is the sample data
Column A Column b Column c Column d Column E Column F

 

[bobsan42]

It is not terribly clear what exactly do you match to get the value from E.
How are column ABCD connected?

 

[AliGW]

Try this in F2 copied down:

=IFERROR(INDEX($E$2:$E$16,MATCH(A2,$C$2:$C$16,0),0),"")

 

[satish78]

Worked like a charm.
Thanks AliGW. I appreciate your help.

 

[satish78]

Hi AliGW,

Its working but could not match AB CD columns it only matches a & C columns and does not match B & D.

 

[AliGW]

Hi AliGW,

Its working but could not match AB CD columns it only matches a & C columns and does not match B & D.

It doesn't need to - they are all the same value. Or are you saying that your sample data isn't telling the whole story?

 

[satish78]

Hi AliGW,

I want to Match A & C columns along with partial Match B & D columns and if match found get "Column E" data into "F column".
Here is sample worksheet.

ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF

 

[oldbrewer]

are you now saying you want to match the name in A with any name in C ?