Announcing Tech Community AI Language Translation Beta

Hi All,

i would like to ask to a question for replacing the data each other. i am working two system report invoices and have a problem single item issue ( may be two ). first is main data and second is invoice data. attache file will show you easily what i want. highlighted items are to be replaced each other. main data set is perfect data and invoice data will be matched it.

Thanks

i am using formula in K2, but did not get desired result.

=IF(MATCH(A7,$F$3:$F$21,0)>0,A7,REPLACE(A7,1,11,F7))

i would like to upload file, can anyone tell me where is the option?

Thanks.