Get instant live Excel expert help with LOOKUP Function

I need help with partial lookup, I have setup rules for for exact match but can't find a way for partial match

I am finishing a dynamic financial statement model. I am working on the debt paydown section, with a revolver (which is fed or tapped by cash earnings -or lack thereof). I am using IF functions, maybe Min Max. This is not complex V Lookup and Macros and stuff. Basic Excel formulas, Bus the model is not balancing, and I am unable to fix. I need somebody who has extensive experience in financial models, who understands income statement, who worked as an analyst at a bulge bracket investment bank. This is not complicated, probably very quick and easy, but I want it done right, my way, within the existing model.

I am completing a dynamic financial statement model, a classic Wall Street sell side / buy side model. I am having trouble with the debt pay down in the context of a revolver which is fed by or tapped by cash earnings (or lack thereof). This is simple IF and MIN/MAX statement formulas, nested formulas etc. Not VR Lookup and Macros etc. This is relatively basic. But I can't get it to work. I am NOT an Excel expert. I need somebody who is an expert in THIS type of modeling, financial statement modeling. Somebody who understand Financial statements. I need somebody who worked as an analyst in a bulge bracket investment banking program. I need somebody who has done this exact type of financial statement modeling, with these types of formulas and problems (dynamic, balance sheet always balances, excess cash used to paydown term debt after revolver paid do etc etc etc). I am NOT looking for super smart natural sciences Nobel prize winner in physics. I need somebody who grinded away at night in bulge bracket investment banking program for years, for whom this is child's play (as it indeed is).

INDEX MATCH MATCH function is not working. Can not find the lookup value but i know that it is there and exists. I have tried the trim function to get rid of any necessary spaces but no luck. All i get is #N/A.

Hi I am having an issue with Powerpivot. I am using multiple sheets. They all have identical headers / structure. They contain data for 600+ countries and 50 years. There are three sheets at the moment, life expectancy, death rate and GDP. There is one lookup table containing country code, name, income and region. I am trying to create a dashboard with pivot charges that contrast the data. So I would like to end up with various pivot charts and slicers of Region, Income and year, but when I am trying add year as a slicer it adds each year as its own slicer

I am having trouble with Excel lookup formulas - I need to match two related values (in two separate cells) in one Excel tab, to the same values in another tab, and copy a corresponding name from the second tab into the first one. I can share some of the dataset with you, it is not confidential. The dataset has 2500 records in it, and I would like to find a formula that allows me to return a townland name from one tab in the main dataset, and populate it into the same column in another tab - matched to the same corresponding data in each tab. There may be some examples where the townland name is not visible.

Stuck with a VLOOKUP issue in Excel. Have tried everything from looking up numbers to text, text to columns, copied data into a new sheet, pasted values only, text to columns, lookup values as text and nothing works. I am not new to troubleshooting VLOOKUP issues but this has me stumped.

Vlookup issue. I have tried everything to lookup the USD prices in the GEN TRUCK tab from the BIS tab sheet. I have changed the formats from numbers to text by using text to columns in both sheets. I have changed to numbers by multiplying the data *1.

Hi I need to create a V lookup from the fixed prices tab into the calculator on the front sheet. It needs to reference the LDZ, the consumption band and then add on the brokers commission please.

On Tab "Employee Information" I need Column V to use the if formula from Column P to decipher whether the Employee file Single "S", Married "M", or Do Not Withhold "DNW". Once it deciphers this, if the answer is "S" I need it to lookup the tab "Payroll Calculator" AG4 for the first Employee, and find the Gross Taxable Percentage from the named group "SingleFedTaxTable" or tab "Data" range H14 through I20, to find the percentage on J14 the J20. If the answer is "M" I need it to lookup the tab "Payroll Calculator" AG4 for the first Employee, and find the Gross Taxable Percentage from the named group "MarriedFedTaxTable" or tab "Data" range H26 through I32, to find the percentage on J26 through J32. If the answer is "DNW" I just need it to answer with a 0.