Here are some problems that our users have asked and received explanations on
I need to do a "fuzzy" index match or vlookup, but I am having trouble getting the wildcards to work. And I want to be able to do this without the fuzzy lookup add in, because I want to write a macro for this.
Solved by T. H. in 20 mins
I am creating formula based on a pivot table,
When the table changes shape then the formula does not follow the new shape.
I believe there is a way to do this with the "lookup" function but need help on how.
Solved by Z. J. in 29 mins
Sum of data by product using a lookup value - i've got a complex sheet where i need to do a summary by product type but it's got to get the values from a lookup and i cant get my head around the calculation. I think its a sumproduct and sumif but the calculations just not working for me. can you help?
Solved by B. B. in 21 mins
I need help with 2 things. Looking at a report and looking for matches within rows and columns. and a V lookup
Solved by D. J. in 16 mins
I'm looking for a help on an excel formula to return a lookup value
Solved by M. A. in 20 mins
I have to lookup the value in Cell C3(tab2), in the coloumn D (tab1). Where there is a match, I have to sum all the values in Coloumn J(tab1) divided by the sum of values in Coloumn F(Tab1)
Solved by I. J. in 15 mins
i need to have a formal v lookup a cell and give the insert one cell to the right as well as the 3 cells beow
Solved by B. C. in 21 mins
Help me to lookup data from main sheet to arrange same in other sheet in a column.
Solved by M. Y. in 15 mins
Using the hlookup function in cell h11 to calculate freight cost based on the shipping class and state to which the shipment is going. Freight Cost can be referenced on the "Freight Cost" lookup table (range e5:n8). Be sure to use appropriate relative and absolute cell references. Hint: you will need to use a funciton within the hlookup function to determine the appropriate row................. Something in my formula is not working. Can you help me?
Solved by G. C. in 20 mins
How do I insert a lookup function in a cell to display a cost?