how to combine concatenate, index and match???? PLEASE HELP!!!

[pennydao]

Hello,
I have sheet 1 as below:
(col A) (col B) (col C) (col D)
1 firstname lastname AddressLine1 ContactGUID
2 Chantal Dewit 6860 SW 76th Ter 9A5A229E-E738-4C7B-8F9E-85FAB84BBFD93
3 Steve Goldfarb 8833 Bayside Ct AA0A610E-5DAC-44DC-ACB7-F77F864347C6

Sheet 2:

(col A) (col B) (Col C) (col D)
1 firstname lastname AddressLine1 ContactGUID
213 Chantal Dewit 6860 SW 76th Ter
906 Steve Goldfarb 8833 Bayside Ct

I wish to lookup the value on sheet 1 in the ContactGUID column which match the result after concatenate sheet 2 A:D

I wish my result for on sheet 2 D column to look like this:

(col A) (col B) (Col C) (col D)
1 firstname lastname AddressLine1 ContactGUID
213 Chantal Dewit 6860 SW 76th Ter 9A5A229E-E738-4C7B-8F9E-85FAB84BBFD93
906 Steve Goldfarb 8833 Bayside Ct AA0A610E-5DAC-44DC-ACB7-F77F864347C6

please help!!!

 

[GCExcel]

Hello,

By adding a dummy column E in sheet 1 where you concatenate the values of A, B, C, you can then use this formula in Sheet2 :

=INDEX(Sheet1!D1:D2,MATCH(CONCATENATE(A1,B1,C1),Sheet1!E1:E2,0))

 

[pennydao]

I tried that but still didn't work. I came up with this

=INDEX(Sheet1!$D$2:$D$1025,MATCH(CONCATENATE('sheet2'!I2,'sheet2'!J2,'sheet2'!K2),Sheet1!$A$2:$C$1025,0))

Still did not work :/ what else can I try?

 

[pennydao]

Ok I fixed it and it worked! thank you so much!!!