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!”
Here are some problems that our users have asked and received explanations on
Someone from your group had assisted me in creating a VLookup for my document. I am noticing that some of the rules are not working properly. When entering the store number it should auto populate the address, city, state, zip, store MGR, Area MGR, Market MGR and starting pay. It’s not doing that for all of the cells Also, nothing happens when I enter in store # 090004 & 090006.
Also, could you lock down those fields, so the formula does not get deleted in error?
Solved by G. J. in 22 mins
im stuck on a vlookup formula if i attach the spreadsheet can you help
Solved by Z. E. in 11 mins
I am trying to brainstorm on how to get a formula to look up a contract, if it is between a certain date range return the value for the % associated with it. I have 2 tabs that it would be using in a spreadsheet, then it would need to multiply the MPDQ on spreadsheet 1 x the %x a fixed amt 1.084 to give the desired result.
I am not sure if I need to say it is November 1 and put in the formula that if it falls between this date range vlookup contract and return this value, or would it be easier to match index and do the calculation?
Solved by I. U. in 25 mins
I need a formula to put in the column B in the COST SUB TAB, calculating excel table subtotal per resource from Column B in the Cost Plan tab (the result needed is similar to a Pivot TableNot with Resources in the Row and the Sum ofForecastedUnits in the values, however i would like a formula instead the pivot table for a similar result).
Not sure if it's the SUMIF formula + vlookup the most appropriate or somethingelse. Please help me.
Solved by F. D. in 29 mins
I need a formula in the 2nd tab, to calculate the subtotal per resource from the 1st tab.
Not sure if it's the SUMIF formula + vlookup the most appropriate or somethingelse. Please help me.
Solved by V. E. in 27 mins
To analyze the data with Microsoft Excel software for several sub tasks below:
1.1 Count the number of Product Family for PF12 (using COUNTIF formula).
1.2 Display the name of the customer who most frequently complained (using INDEX formula
with other possible formulas).
1.3 List all complaint types raised by the customer identified in the task 1.2 (using VLOOKUP
formula with other possible formulas).
1.4 Establish four pivot tables in a new sheet called “Executive Summary” for the Customer
Solved by A. B. in 28 mins
I’m trying to do a Vlookup formula to have column ‘Q’ – INITIAL Risk Level populate data I put into column “P” – Occurrence (Failure/Cause). So, Column P should pull in numbers 1-5 from the “Risk Tables” sheet, then, once I enter in 1, 2, 3, 4, or 5, the risk level should populate in column ‘Q’, with the appropriate color “yellow or red”. Similar to what’s happening in column ‘V’ and ‘X’. Please see if you can assist in this formula headache.
Solved by B. U. in 14 mins
I already found a simple VLOOKUP formula example, and I'm now trying to organized/sort this excel file to only show me the Contact ID who's mailing zip code return with a correct state value.
Solved by M. A. in 23 mins
sir what s d formula for vlookup..................
Solved by E. Q. in 11 mins
looking for some help with a vlookup formula that was done incorrectly
Solved by E. A. in 25 mins