<div>
Yea I get that but only when DHC Detail Column A has a match on Scores column A
</div>


<div>
So basically <br />
<br />
If Scores A = DHC Detail A then<br />
<br />
using the e* from Scores<br />
=IF(E5=&quot;_IM1_/img/samples/<wbr />flag_green<wbr />.gif_IM2_D<wbr />eal Status_IM3_&quot;,5,IF(E5=&quot;_IM1<wbr />_/img/samp<wbr />les/flag_y<wbr />ellow.gif_<wbr />IM2_Deal Status_IM3_&quot;,3,IF(E5=&quot;_IM1<wbr />_/img/samp<wbr />les/flag_r<wbr />ed.gif_IM2<wbr />_Deal Status_IM3_&quot;,1,1))) &nbsp; <br />
&nbsp;<br />
and if no match column should be left blank
</div>


<div>
Not getting you exactly. Are we on one of this two sheets with the formula?<br />
I reckon &quot;Scores A&quot; means &quot;Scores A on the same row as the formula&quot;?
</div>


<div>
<div class="content wysiwyg-content">
I currently have the following formula (below) which works great but I now need to tweak it to work multi sheet.<br />
<br />
=IF(P5=&quot;_IM1_/img/samples/<wbr />flag_green<wbr />.gif_IM2_D<wbr />eal Status_IM3_&quot;,5,IF(P5=&quot;_IM1<wbr />_/img/samp<wbr />les/flag_y<wbr />ellow.gif_<wbr />IM2_Deal Status_IM3_&quot;,3,IF(P5=&quot;_IM1<wbr />_/img/samp<wbr />les/flag_r<wbr />ed.gif_IM2<wbr />_Deal Status_IM3_&quot;,1,1)))<br />
<br />
My workbook now has the following tabs<br />
<br />
DHC Detal<br />
Scores<br />
<br />
before in column AB I had the formula above but now rather than look at the existing sheet line it needs to look at TAB Scores and when the value in DHC Detail column A has a match somewhere in Scores Column A then the formula would look at the value in Scores column E
</div>
</div>


I currently have the following formula (below) which works great but I now need to tweak it to work multi sheet.

=IF(P5="_IM1_/img/samples/flag_green.gif_IM2_Deal Status_IM3_",5,IF(P5="_IM1_/img/samples/flag_yellow.gif_IM2_Deal Status_IM3_",3,IF(P5="_IM1_/img/samples/flag_red.gif_IM2_Deal Status_IM3_",1,1)))

My workbook now has the following tabs

DHC Detal
Scores

before in column AB I had the formula above but now rather than look at the existing sheet line it needs to look at TAB Scores and when the value in DHC Detail column A has a match somewhere in Scores Column A then the formula would look at the value in Scores column E

Need Help Converting an Excel formula to work on multi sheet

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