Excel lookup using multiple cells

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,943
Office Version
365
Platform
Windows
Try
=IF(COUNTIFS(TA!B:B,H26,TA!E:E,"*"&N26&"*",TA!D:D,"<="&K26+3,TA!D:D,">="&K26-3)>0,"yes","no")
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
35,943
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,090,120
Messages
5,412,556
Members
403,432
Latest member
cr2141

This Week's Hot Topics

Top