Avatar of Michael O'Flaherty
Michael O'Flaherty
Flag for New Zealand

asked on 

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

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
EE invest try.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Saqib Husain

8/22/2022 - Mon