Michael O'Flaherty
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
Michael
EE invest try.xlsx
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
EE invest try.xlsx
Can you show what it woul look like after the required posting is done?
ASKER
Hi Saqib
Thanks for your interest.
You are the only one to respond.
I have solved it today by inserting new columns A and B with the following in cell A9.
'=IF(I9<>$T$2,"",CONCATENATE("Term ",LEFT(MID(D9,FIND("#",D9),LEN(D9)),FIND(" ",MID(D9,FIND(" ",D9)+1,LEN(D9)))-5)))
Cheers
Michael
Thanks for your interest.
You are the only one to respond.
I have solved it today by inserting new columns A and B with the following in cell A9.
'=IF(I9<>$T$2,"",CONCATENATE("Term ",LEFT(MID(D9,FIND("#",D9),LEN(D9)),FIND(" ",MID(D9,FIND(" ",D9)+1,LEN(D9)))-5)))
Cheers
Michael
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Maybe you copied this formula from some other file.
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.
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.