<div>
your question is vague, can you please upload a sample.<br />
<br />
what do you mean by Shift P
</div>


<div>
Shift P is a tick in wingdings a character
</div>


<div>
so that would mean to check against the font name and also font boldness correct? &nbsp;for example if it is just capital P, then it should not trigger?
</div>


<div>
Just font name....If.there trigger if blank not there over on...
</div>


<div>
Array Formula<br />
=iferror(vlookup(ac10&amp;c6,c<wbr />hoose{1,2}<wbr />,'sheet1'!<wbr />d7&amp;'sheet1<wbr />'!d10:d29,<wbr />'sheet1'!c<wbr />10:c29),2,<wbr />0),&quot;&quot;)..<br />
<br />
Works finds the first irration how do I find next in sequence...
</div>


<div>
i think there is a mistake in your abovementioned formula, how could you join two range not same size<br />
<br />
is it a mistake &nbsp;sheet1'!d7 is a single cell and sheet1'!d10:d29 is bunch of cells?<br />
<br />
can you plz upload a sample file.
</div>


EE.xlsx

<div>
<div class="content wysiwyg-content">
Hi Experts using Excel 2010<br />
<br />
Need a formula to look in Sheet2 column(s) C6, and AC10 and if C6 is a “tick” wingding 2 (shift P) and AC 10 is Apples, then look in Sheet 1 Range C10:M100….and if column D10:D100 has a tick then return all the customer names in column C10:C100 and input those into Sheet2 Range C10:C30.
</div>
</div>


Hi Experts using Excel 2010

Need a formula to look in Sheet2 column(s) C6, and AC10 and if C6 is a “tick” wingding 2 (shift P) and AC 10 is Apples, then look in Sheet 1 Range C10:M100….and if column D10:D100 has a tick then return all the customer names in column C10:C100 and input those into Sheet2 Range C10:C30.

Tricky Formula to look up data

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.