“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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".

Solved by M. J. in 12 mins

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

Solved by G. H. in 16 mins

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

Solved by M. E. in 25 mins

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

Solved by M. B. in 28 mins

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.

Solved by B. B. in 11 mins

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

Solved by D. D. in 28 mins

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

Solved by O. E. in 25 mins

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.

Solved by M. L. in 26 mins

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

Solved by D. D. in 18 mins

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%)))

Solved by X. W. in 25 mins