Get instant live Excel expert help with VLOOKUP formula

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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