#ifstatement

Hello all, I'm trying to assign all of the expenses that have "Public" in the expense description as operations management in nother field and all other expense that don't have "Public" as "Some other Department". When I run the if statement below as part of my Select query it returns all of...

hi, I need some help with a vlookup, any help would be greatly appreciated! I need to look at column 1 and return the value specified in the lookup table, but if the number doesn't exist in column 1 lookup table, i want to lookup column 2 and return the value based on the lookup table. Any...

Hey Team! Im stuck on a excel problem. Wonder if someone could give me some advice? Its a simple scenario, but Im having trouble with the function. Lets say you are going to get paid out based on the performance if your company. So any net income over $425,000 but under $725,000 you get 100%...

Hi, a run time error 1004 occurs whenever the macro has finished looping through sheet names which contains "Country Financials". Your help please on what workaround should I do to prevent the error and continue to save the workbook. Thank you in advance for your help! Sub FormatFiles() Dim ws...