Search Lookup with multiple criteria

[NotSwank]

Hey All, I've made some progress on this thanks to another user (AlKey). However, I've had to add in some additional criteria.

Please see the table below. The end result I need is in blue. Essentially I need to put a formula in column c that looks for a match from column E that falls in the min / max range of columns G & H. If it doesn't meet that range criteria at the first match it hit it needs to continue down column E. If there are no matches then it needs to return a blank space.

If you look at row 4 & 5 you can see a good example of this.

So far I have:

Please Login or Register  to view this content.

I'd also like it to ignore blanks so I can have my lookup range be larger as the ideas is this list will grow; So I could do $E$1:$E$20 (if I do that now if marks all of them as blank).

Row\Col	A	B	C	D	E	F	G	H
1	1234ABCtgde	$51.00	<Blank>		ABC	5555	0.00	9.99
2	ewhhfruDEFrefjoi	$8.00	6666		DEF	6666	0.00	9.99
3	ewhhfrdwefurefjoi	$100.00	<Blank>		GHI	7777	0.00	49.99
4	fretgtevdGHIerfrfe	$51.00	8888		GHI	8888	50.00	999.99
5	fretgtdrtvdGHIerfrfe	$29.99	7777

Any help you could provide would be great!

[NotSwank]

I figured this out. I used Sumproduct

Please Login or Register  to view this content.