Hello,
Hello,
I am trying to sort through some bank records. I am trying to pull transaction amounts from cell G into cell H if cell E contains partial text (not case specific). For example if cell E3 contains "MUGSY" then display "-17.25" in cell H3. It must search for partial text because some of the transactions I have contain the last 4 of the card that was used (See E5/6/7) and I want to pull both of those values into the same column regardless of which card was used.
It would also be helpful if I could pull the values from G if column E contained either "MH CAFE" or "INTEL OC" into the same column.
Im trying to figure out how much my wife and I are spending when we eat out for lunch at work.
Any help would be greatly appreciated.
Thanks,
Alex
Hello,
I am trying to sort through some bank records. I am trying to pull transaction amounts from cell G into cell H if cell E contains partial text (not case specific). For example if cell E3 contains "MUGSY" then display "-17.25" in cell H3. It must search for partial text because some of the transactions I have contain the last 4 of the card that was used (See E5/6/7) and I want to pull both of those values into the same column regardless of which card was used.
It would also be helpful if I could pull the values from G if column E contained either "MH CAFE" or "INTEL OC" into the same column.
Im trying to figure out how much my wife and I are spending when we eat out for lunch at work.
Any help would be greatly appreciated.
Thanks,
Alex