Match Value and select data?

[vt1]

Hi,
I am trying to achive below in ColumnD

Header A Header B Data If exists (based on header A to header B) then drop data into Column D
A1 A1 test1 test1
A2 A2 test2 test2
A3 A5 test3 Not Exist
A4 Not Exist
A5 test3

Please comment.

Thanks.

[Fotis1991]

Hi

For me your request is not clear. Can you upload a small sample workbook?

[vt1]

Hi,
I am having challanges to upload the file.
Consider Header A is first columns, Header B is second column and Data is third column.
I am trying to match A and B and then drop value from Data if it match.
Thanks

[Fotis1991]

Let's try once.

In D1...?

=IF(A1=B1,C1,"")

[vt1]

Thanks but this may not work as columns values in A2 and C2 are not in order.
is there any way to work on range

[Fotis1991]

I am sure that i can give you, your solution, but i am not able to understand how your data looks like....

That's why i asked a SAMPLE workbook. Sorry..

[jake.masters]

You could use the =MATCH() function to see if there is a match, then the =INDEX() function to locate this data based on the location MATCH returns. It will be hard to figure out, though, without any reference, as fotis was saying...

[vt1]

Thanks Jake,
I got it. Now only challange is to handle errors.
Any idea about it. See attached and comment.

[Ace_XL]

In 2003 or earlier versions
=IF(ISERROR(INDEX($B$2:$C$4,MATCH(A2,$B$2:$B$4,0),2)),"",INDEX($B$2:$C$4,MATCH(A2,$B$2:$B$4,0),2))

In later versions, simply
=IFERROR(INDEX($B$2:$C$4,MATCH(A2,$B$2:$B$4,0),2)),"")

and copy down

[jake.masters]

Couldn't have said it better myself.

[vt1]

Couldn't have said it better myself.

Thanks for helping it out.