Copy entire row to another sheet if value matche

[sambomim]

Hello guys,

I have 2 sheets, and they share one value, the customer ID, so, I need to cross the information between. Taking in consideration the Customer ID, I need to know the page URL who generated the sale.

What I've accomplished until now? With the the countif function I was able to see if a value from sheet 1 is also in sheet 2. What I need? If Customer ID on sheet 2 matches customer ID of sheet 1, that I need to copy the value of page URL of the row of sheet 2 to sheet 1.

Hoping that I was clear. Thanks in advance for all your help.

Sheet 1

Nome Paciente

Customer ID / Nº Processo

Data criação Paciente

Contacto Paciente

Email Paciente

Clinica

Data Consulta

Tipo Consulta

Estado da Consulta

Estado Proposta

Data Venda Proposta

Tipo Proposta

Valor Proposta €

id_referenciador_pt

Paciente KO

Provisório

Formação

MTC OK

Valor Faturado €

Website URL

Nam1

196835901

03-04-2022

xxxx1

email address removed for privacy reasons

Braga

10/08/2021

Presencial

Efetivada

Comprou

01/04/2022

Transplante capilar

3250

NAO

NAO

NAO

SIM

3250

Nam2

239875651

03-04-2022

xxxx2

email address removed for privacy reasons

Braga

02/04/2022

Presencial

Efetivada

Comprou

02/04/2022

Transplante capilar

4500

9995

NAO

NAO

NAO

SIM

4500

Nam3

205898401

03-04-2022

xxxx3

email address removed for privacy reasons

Braga

02/04/2022

Presencial

Efetivada

Comprou

02/04/2022

Transplante capilar

4250

8902

NAO

SIM

NAO

SIM

0

Nam4

228816855

03-04-2022

xxxx4

email address removed for privacy reasons

Braga

02/04/2022

Presencial

Efetivada

Comprou

02/04/2022

Transplante capilar

4500

NAO

NAO

NAO

SIM

4500

Nam5

199677751

04-04-2022

xxxx5

email address removed for privacy reasons

Braga

04/04/2022

Presencial

Efetivada

Comprou

04/04/2022

Transplante capilar

4500

NAO

NAO

NAO

SIM

0

Sheet 2

First Name	Phone Number	Email	Website URL	Contact ID	Contact ID Match
Nam1	xxxx1	email address removed for privacy reasons	https://www.example.com/1	196835901	0
Nam2	xxxx2	email address removed for privacy reasons	https://www.example.com/2	239875651	1
Nam3	xxxx3	email address removed for privacy reasons	https://www.example.com/3	205898401	1
Nam4	xxxx4	email address removed for privacy reasons	https://www.example.com/4	228816855	0
Nam5	xxxx5	email address removed for privacy reasons	https://www.example.com/5	199677751	0

[#2]

@sambomim 

first

Turn on the Inquire add-in

then

Compare two versions of a workbook by using Spreadsheet Compare

or with VBA, if this is posible in your excel Version.

the code or the file is from a long time ago and I don't even know where it can be from (internet site or from me), but it should work. Code can be found in the file.

Hope I was able to help you :).

NikolinoDE

I know I don't know anything (Socrates)

[#3 · Accepted solution]

@sambomim 

An alternative could be Power Query.

[#4]

Thanks @NikolinoDE for your help! ;)

[#5]

Thanks! This worked for me!!