Match Range One with Range Two and Return Info from Range Three

[ozbeachbum]

Where there is a Match in Range H2:H18 to Entries in Range D2:D18 then the corresponding entry in F2:F18 would be shown in (B2:B18)

EG: H4 Master D8 Master F4 hl (B8 hl)

EG:H2 H8 & H14 Test D2 D12 & D14 Test F2 F8 & F14 h (B2 B12 & B14 h)

240811 entries from 2 criteria.xlsx
	B	C	D	E	F	G	H
2			Test		h		Test
3
4			Roam		hl		Master
5
6			Reset		hs		Test 01
7
8			Master		h		Test
9
10			Razor		b		Reset
11
12			Test		hss		Test 02
13
14			Test		h		Test
15
16			Test 01
17
18			Test 02
19
20	Where there is a Match in Range H2:H18 to Entries in Range D2:D18 then the corresponding entry in F2:F18 would be shown in (B2:B18)
21	EG: H4 Master D8 Master F2 hl (B8 hl)
22	EG:H2 H8 & H14 Test D2 D12 & D14 Test F2 F8 & F14 h (B2 B12 & B14 h)
Blank

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F	G	H
1
2		h		Test		h		Test
3
4				Roam		hl		Master
5
6		b		Reset		hs		Test 01
7
8		hl		Master		h		Test
9
10				Razor		b		Reset
11
12		h		Test		hss		Test 02
13
14		h		Test		h		Test
15
16		hs		Test 01
17
18		hss		Test 02
19
Sheet5

Cell Formulas
Range	Formula
B2:B18	B2	=IF(D2:D18="","",XLOOKUP(D2:D18,H2:H18,F2:F18,"",0))
Dynamic array formulas.

Note that if 2 cells in column H have the same value (H8 and H14), the first row will be used.

 

[ozbeachbum]

Thanks once again Eric.
Greatly appreciated.
Dave.