Hello everyone,
Can anyone help me please?
I need a formula that will look between columns AX:BI for the amount of 500 and if this criteria is met to then copy the text from AE to where the formula is on a different sheet (same workbook).
I would prefer for all the returning text to read as a list with no blanks.
In other words i would prefer to not have a list full of blanks where there has been no 500 in AX:BI.
To quickly explain the relevance:
AX:BI shows funding, these are various amounts but the 500 is the startup grant for the business. there is no text in these columns. If there are blanks then the business did not get a grant to startup or have just enquired.
AE is the type of business that is intended to be started. This is always text.
Any ideas guys? once again thanks for your time and help.
Bookmarks