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
MichaelEE invest try.xlsx