Match Data in two column and produce another data.

**ryoka012** · 08-17-2015, 01:56 AM

Hi,

What formula can i use for my description above.
Example

I have 5 column
Excel.png

Can anyone help me with this problem.
Thanks.

**oeldere** · 08-17-2015, 02:04 AM

you did not showed the expected result.

on the given information, you could use index / match

**samba_ravi** · 08-17-2015, 02:09 AM

Try the below formula and copy towards down
=IFERROR(INDEX($A$1:$A$5,MATCH($D1,$B$1:$B$5,0)),"")

Please Login or Register  to view this content.

**ryoka012** · 08-17-2015, 02:21 AM

Hi oeldere,

Thanks for your reply,

I have added an image to easily understand.

Thanks.

**samba_ravi** · 08-17-2015, 02:24 AM

=IFERROR(INDEX($A$2:$A$6,MATCH($e2,$B$2:$B$6,0)),"")

Please Login or Register  to view this content.

**oeldere** · 08-17-2015, 02:29 AM

I am not able to open PNG files (on this forum).

Some forummembers don't like PNG since we can't work in it. In that case a small excel file, will be better.

Match Data in two column and produce another data.

LinkBack

Thread Tools

Rate This Thread

Display

Match Data in two column and produce another data.

Re: Match Data in two column and produce another data.

Re: Match Data in two column and produce another data.

Re: Match Data in two column and produce another data.

Re: Match Data in two column and produce another data.

Re: Match Data in two column and produce another data.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Compare Data in 2 Columns in 2 sheet When there is a match transfer data from 2nd Column

[SOLVED] Extract data from third column where data in two other columns match

Do a partial match of data then copy data from a different cell into a new column

Do a partial match of data then copy data from a different cell into a new column

Do a partial match of data then copy data from a different cell into a new column

Macro formula to match two columns and Produce result in fourth column.

function problem to produce data value with two condition of column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions