IF Function help

[DMTC]

Hi,
I am new to the forum and not a complete amateur to excel, but I’m starting to try to use it more in my day to day life to be more organized and after many hours of working on this I would greatly appreciate guidance.

What I am trying to do, is trying to make a multi sheet workbook that will show my bills, income and other information by month (a sheet for all twelve months), then, I have one sheet (Bills Paid Tracking) that has all the months across the top and all the bills down the side (not sure my terminology is correct) and when I enter the pay date in let’s say the January sheet, paid date cell, I want it to then put a “Yes” in the appropriate cell in the “Bills Paid Tracking” Sheet.

At one point (I think by accident) I got it to do that, but if I changed the data it did not update.

I hope this makes sense and would greatly appreciate your help… It seems like something so simple and I am just completely stuck. I originally wanted it to display an Icon, but at this point I don’t care what it says just so it’s something.
Thank you in advance!

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[FDibbins]

Agree with Alan regarding a sample WB, however, I would suggest a slightly different approach to what you are looking at.

Instead of having a sheet for each month, rather, have 1 sheet to enter ALL data into, along with a date with each entry. Excel is very good at extracting data froma table like this, and has many fairly simple formulas and built-in functions designed to work this way. INDEX/MATCH and VLOOKUP are 2 that spring to mind right now, but there are lots that could also work

[DMTC]

Thank you!! I attached an example - the pink tabs are basically what I have now, on the blue tabs is desired and I added data to what I wanted my end result to look like. The cells in reference; "Desired January 2015" sheet, cells H8 on down ( I think end of working sheet is H189), the "Pay Date" and apply the information to the "Desired Payment Tracker" Starting at B5. If there is a "date" in the H8 cell then put a "yes" in cell B5.
I feel like I just made it more confusing

[FDibbins]

1st, correct the spelling of the Janurary 2015 sheet
2nd, remove the "Desired" part from the sheet name
3rd, Im not sure why some of the rows do not have YES in them. but this, copied down, will pull in teh value from column C on the month sheet...
=INDEX(INDIRECT("'"&B$4&" 2015 '!$C$8:$C$36"),MATCH('Existing Payment Tracker'!$A5,'January 2015 '!$A$8:$A$36,0))
If you want that to show YES for any payment >0...
=IFERROR(IF(INDEX(INDIRECT("'"&B$4&" 2015 '!$C$8:$C$36"),MATCH('Existing Payment Tracker'!$A5,'January 2015 '!$A$8:$A$36,0))>0,"YES",""),"")

[DMTC]

Mainly the reason I did it the way I did is because its the only way I knew how to do, im not familiar with VBA or the other tools - I will have to look into that.
If using the other methods wont I still run into this same issue?

Thank you for all your input!
Michele

I will also be sure to click on the stars, resolved etc

[FDibbins]

With the layout you have on the month sheet, if you are set on having it that way, then 12 sheets would probably be the way to go, but I will take another look and see if I can come up with an alternative (unless my suggestion in post 5 is what you want?)

edit: Make sure you dont have any leading or traing spaces in your headings (check February in both Tracker sheets, for example)

Hi neighbour, by the way )

[DMTC]

Ford,
this was QUICKLY thrown together to show Alan (and whom ever) what I was trying to accomplish so I did not check spelling as it is NOT my actual sheet, since its my birth month I do actually know how to spell it I'm sure you have had typos you never caught The "Desired" portion was as per Alan he said to show what I have and what I am looking to accomplish, hence the "desired". The "Yes" is what I want it to say, YES, that bill was paid and populated from the sheet I enter the date.

[DMTC]

Sorry on my, not so quick replies, i'm trying to do a couple things at one time. I'm not set on the layout, like I said I just don't know any other way.
Yes, I see that we are neighbors

[FDibbins]

Sorry, I wasnt busting on you for spelling (some were not exactly spelling anyway, just extra spaces) we have many many members who have unintentional typos, then wonder why a formula does work

(whicg day in jan? Im 21st)

[DMTC]

And apparently I just hit the wrong button and deleted my post -

HAHAHA!! Mine too, 21st! Happy Birthday! I know all about typos and formulas not working - been there, done that! I know you weren't busting on me, you are just helping me have a nice looking spreadsheet! I will be taking a look at the info and formulas you sent me here in a couple minutes. I appreciate your help, I am very frustrated and truthfully ready to throw in towel.

[FDibbins]

Happy early birthday, does that mean we are twins?

The formula I posted should give you what you need, you may just need to adjust the ranges - dont throw anything in just yet, we will sort this out

[DMTC]

I finally got to look at this, I think i'm confused or either I didn't explain myself correct. What I am looking to do is really just for me at a quick glance to make sure I paid a bill or didn't miss one. In words (im sorry I cant speak the language) it should read (not saying this is a real formula) IF H8 is NOT blank put YES in B5, if H8 is blank do nothing (if I can). What I want it to do in my mind is so simple I dont think that is what those formulas are having it do. If it is, then I don't know where to enter it

LOL, No cant be twins, i'm not smart enough to be your sibling

[FDibbins]

I think that is what I gave you. See the attached