Matching last 7 digits from a column in a sheet to last 7 digits in another column, if unmatched bring over column B and column c Value

[Harry_1234]

Hi Guys,

I am looking for some help where I have a sheet XYZ in excel with column A that I would like to compare last 7 digits with Column A of sheet ABC. Note if there is a match/unmatch in Column F of sheet XYZ and also, bring over the values of Column B and Column C from sheet ABC to Column G and H of sheet XYZ
sheet XYZ:

Dialed Number	dESC	ct	CT_Desc	Script
81245671​	XYZ_UK_P	XYZ_UK_P	NULL	XYZ_UK_P
81245679​	XYZ_UK_S	XYZ_UK_S	NULL	XYZ_UK_P

SHEET abc:

Number	Call Type	Script	Original Number
35311392766	DI_EP	DI_Dep
3531242240000	DI_SGR	DI_SGR
35311245671	Altana	Altana

 

[bebo021999]

We could not find cell reference of both sheets, its hard to see what cells are raw data and what cells are the output.
Try again to display cells row/column and hightlight the output resutls.