<div>
Can you show what it woul look like after the required posting is done?
</div>


<div>
Hi Saqib<br><br>Thanks for your interest.<br>You are the only one to respond.<br><br>I have solved it today by inserting new columns A and B with the following in cell A9.<br>'=IF(I9&lt;&gt;$T$2,"",CONCATENATE("Term ",LEFT(MID(D9,FIND("#",D9),LEN(D9)),FIND(" ",MID(D9,FIND(" ",D9)+1,LEN(D9)))-5)))<br><br>Cheers<br>Michael
</div>


<div>
Maybe you copied this formula from some other file. <br><br>If I try to use the formula in the file you uploaded I have to make a few changes to be able to get "some" result.
</div>


<div>
<div class="content wysiwyg-content fr-view">
I have a sheet that shows transactions. Some of these transactions need the amount to be put into specific cells on another sheet depending on criteria.<br><br>I think what's required is a combination of ISNUMBER and LOOKUP, which I've tried but tripped up on.<br>I'd prefer formulae rather than VBA<br><br>The file is attached with a description of what's required in cells F48 to F55<br><br>Many thanks<br>Michael<br><a href="https://filedb.experts-exchange.com/incoming/2021/08_w33/1569104/EE-invest-try.xlsx" rel="ugc">E</a><a href="https://filedb.experts-exchange.com/incoming/2021/08_w33/1569104/EE-invest-try.xlsx" rel="ugc">E invest try.xlsx</a>
</div>
</div>


EE-invest-try.xlsx


I have a sheet that shows transactions. Some of these transactions need the amount to be put into specific cells on another sheet depending on criteria.
I think what's required is a combination of ISNUMBER and LOOKUP, which I've tried but tripped up on.
I'd prefer formulae rather than VBA
The file is attached with a description of what's required in cells F48 to F55
Many thanks
Michael
E
E invest try.xlsx

Excel -bringing data from one sheet to another depending on multiple criteria

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.