<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.

your question is vague, can you please upload a sample.

what do you mean by Shift P

Shift P is a tick in wingdings a character

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

Just font name....If.there trigger if blank not there over on...

Array Formula
=iferror(vlookup(ac10&amp;amp;c6,choose{1,2},&amp;#39;sheet1&amp;#39;!d7&amp;amp;&amp;#39;sheet1&amp;#39;!d10:d29,&amp;#39;sheet1&amp;#39;!c10:c29),2,0),&amp;quot;&amp;quot;)..

Works finds the first irration how do I find next in sequence...

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

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.