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

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?

Solved by D. H. in 14 mins