How to match values from 2 different tables

Good afternoon



Help with the issue bellow would be much appreciated



On example 2 in column A I have frequency numbers (example 1 will be column C) that match the ones in example 1 column c (with a different format) I need to fill column E and F with the values in example 2 column d.



This will need to be based on column C of example 2 (F or H) matching the value on Row 1D and 1E and the frequency numbers

My apolagies try the new one

Originally Posted by FDibbins

I dont think the file you uploaded matches your question?

	B	C	D	E	F	G	H	I	J	K	L	M
3		Example 1								example 2
4									1	OXFORD CIR	F	1219
5				F	H				1	OXFORD CIR	H	336
6	1002 LD1	TS 001	name						750	BRENT CROS	F	442
7	1002 LD1	TS 750	name						750	BRENT CROS	H	0
8	2001 LD1	TS 451	name						451	LIVERPOOL	F	801
9	2001 LD1	TS 831	name						451	LIVERPOOL	H	387
10	2001 LD1	TS1033	name						831	METRO CENT	F	440
11	2101 LD1	TS 788	name						831	METRO CENT	H	0
12	2101 LD1	TS 453	name						1033	WOLVERHAMP	F	591
13	2101 LD1	TS 846	name						1033	WOLVERHAMP	H	35
14									788	BISHOP AUC	F	240
15									788	BISHOP AUC	H	23
16									453	COLERAINE	F	365
17									453	COLERAINE	H	68
18									846	LUTON	F	295
19									846	LUTON	H	19