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.
![excel_help.jpg](/board/proxy.php?image=https%3A%2F%2Fs28.postimg.org%2F74q0yn8fx%2Fexcel_help.jpg&hash=7016a6883514affd1a47e6535b85e8a3)
Thanks,
Alex