Get instant live Excel expert help with VLOOKUP formula

I have a vlookup formula in a cell on a summary tab that is pulling in data from a cell on another tab in the spreadsheet (i.e., "Oct-01, A5). When I drag this formula over 1 cell to the right on the summary tab I want to change the formula on the summary tab of the new cell to "Oct-02". Likewise for the next cell to the right on the summary tab. I want it to change to "Oct-03", because I have 31 tabs for ever day of the month with different amounts for each day. What's happening is when I drag the formulas over on the summary tab they are all are "Oct-01".

my vlookup formula requires a ; and not a , how do I change it back?

I'm using this formula SUMIFS('Raw data'!$AG:$AG,'Raw data'!$L:$L,$A7,'Raw data'!$J:$J,B$1,'Raw data'!$I:$I,VLOOKUP($A$3,$T:$V,2,),'Raw data'!$A:$A,B$2) -'raw data'! is the worksheet (table array) where I reference several critieria such as: -Datatype (Actual, budget, forecast) -Year -Operating company (A, B, C) -Month All are straightforward except the month choice, which looks month in name format (June) reference a table & returns a value in that table (value is 6 for June) How do I copy this for YTD, where i want month to be current month (06) and less (Months 01-05)? Thank you

I need some help with a quick vlookup formula between two sheets

Hi I'm a novice and I'm trying to do a formula that I think needs 2 if's and a vlookup. but cant seem to get it to work.

i have a table with 6 rows and 9 columns and using a vlookup and have three vlookup formulas same formula just referencing different % which are located in the different columns yet its not working properly

Need to find a formula that lets me take the average of a part of the table if it's earlier column matches certain text. Vlookup maybe? Not adept with that

In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text “Invalid Staff ID” should be displayed by the formula.

I am trying to make specific cost calculations by using VLookUp to access the Equipment rate instead of the Direct Rate. I keep retrieving #NA. Need solution to formula. Calculations are done in N Cost Sched thumb tab. Rates come from Equip Rates thumb tab

Currently using this formula to check a second sheet if a certain column has Category B, if so it does some math. I need to change it to if the cell has catagory B OR catagory E. I believe I need the OR statement in there somewhere, but I can't figure it out. =IF(VLOOKUP($A4:$A4,'VIP31'!$A:$E,5,FALSE)="Category B",(($F4*(VLOOKUP($A4,'VIP31'!$A:$B,2,0)%)*2%)))