I'm having a problem understanding how to get started on a formula. I'm working on a way to use Excel to help with my bank statements, I import the saved csv data from my bank and want to verify if a bill in my budget has cleared and if it has then put yes beside it.
Data i'm searching through is in colum D and goes from D2 through D10000
I want to compare it to data in colum I that goes from I10 through I21
If any of the dollar amounts in colum I matches dollar amounts in colum D then put "yes" in colum K that would go from K10 through K21 beside what matches.
I have been working diffrent formulas to go in each cell of K but have yet to get anything working. =if(D2:D10000,I10,"yes","") Can anyone point me in the right direction while understanding i'm not good with these formulas at all.
Thanks,
Bookmarks