SOLVED

Copy entire row to another sheet if value matche

New Contributor

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 PacienteCustomer ID / Nº ProcessoData criação PacienteContacto PacienteEmail PacienteClinicaData ConsultaTipo ConsultaEstado da ConsultaEstado PropostaData Venda PropostaTipo PropostaValor Proposta €id_referenciador_ptPaciente KOProvisórioFormaçãoMTC OKValor Faturado €Website URL
Nam119683590103-04-2022xxxx1email address removed for privacy reasonsBraga10/08/2021PresencialEfetivadaComprou01/04/2022Transplante capilar3250 NAONAONAOSIM3250 
Nam223987565103-04-2022xxxx2email address removed for privacy reasonsBraga02/04/2022PresencialEfetivadaComprou02/04/2022Transplante capilar45009995NAONAONAOSIM4500 
Nam320589840103-04-2022xxxx3email address removed for privacy reasonsBraga02/04/2022PresencialEfetivadaComprou02/04/2022Transplante capilar42508902NAOSIMNAOSIM0 
Nam422881685503-04-2022xxxx4email address removed for privacy reasonsBraga02/04/2022PresencialEfetivadaComprou02/04/2022Transplante capilar4500 NAONAONAOSIM4500 
Nam519967775104-04-2022xxxx5email address removed for privacy reasonsBraga04/04/2022PresencialEfetivadaComprou04/04/2022Transplante capilar4500 NAONAONAOSIM0 

Sheet 2

First NamePhone NumberEmailWebsite URLContact IDContact ID Match
Nam1xxxx1email address removed for privacy reasonshttps://www.example.com/11968359010
Nam2xxxx2email address removed for privacy reasonshttps://www.example.com/22398756511
Nam3xxxx3email address removed for privacy reasonshttps://www.example.com/32058984011
Nam4xxxx4email address removed for privacy reasonshttps://www.example.com/42288168550
Nam5xxxx5email address removed for privacy reasonshttps://www.example.com/51996777510
4 Replies

@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)

 

 

best response confirmed by sambomim (New Contributor)
Solution

@sambomim 

An alternative could be Power Query.

power query website url.JPG

Thanks @NikolinoDE for your help!

Thanks! This worked for me!!