I'm trying to combine Vlookup and Sumif, but so far my attempts have failed!! I have a 2 sheet workbook, the first sheet contains a lookup table, like...

Anyone knows how to write subscript in MSExcel?

I think you first need to record macro and then assign the macro to the button if you need help on macro or VBA try news group...

I want nothing to appear if the value is zero, but it there is a value, I want the value PLUS a dash....

I'd like to input 1-1 or 1-2 or 0-2 etc. but Excel converts my input to a date 1-Jan or sometimes to a large number 37622. I've tried using a custom format...

Good day. The subject of this request may not be accurately stated as I am not sure of the correct terminology to use. I have a worksheet that creates a...

When using the sum function to add subtotals off a spreadsheet I can select only up to 30 cell references. When I go past that limit I get the warning that...

Hi I am trying to use an Excel formula "lookup" in a macro. This macro find the last row in work sheet and then calcualte the range for the lookup_vector...

Is there a command buklit into Excel to find duplicate names on a very large spreadsheet? I know theres a command in FileMaker just wasnt sure if Excel had a...

I am trying to freeze panes but it is freezing from rows 1- 13, how do I change that and only freeze a certain number of panes. Thanks Terry

I'm trying to protect my workbook because someone keeps deleting formulas and i'm constantly fixing it. However i've taken all the step to protect the cells...

I am working on a worksheet where I have 4 columns of numbers. The customer wants columns 1 & 4 averaged and columns 2 & 3 summed. They want these all on one...

I'm trying to set up a payroll spreadsheet. I'm trying to sum up a series of products & even though I have decimal set out 2 places, excel still sums...

I wanted to creat a simple cell forumala such as: =if(activesheet.name = "OCT03","current month","prior month") I get the #NAME result. So is is possible to...

I post this question few days back, but i was not so explicite. I have a sheet, let say "A" where i've posted a table of around 3500 rows. Daily i'm adding...

Hello I think what I'm trying to do is very simple but yet I'm missing something, and just becoming frustrated. Here's the situation. On my spreadsheet, I...

I have a column which is a text column that I spelled out all of the months in a year . What I'm trying to do is.........If Today()=(the month colum) + 7.5,...

I'm working on a major workbook that I need to protect. Someone keeps deleting formulas and I am constantly fixing it. I have taken all the steps to protect...

I'm trying to write a formula for a Right Angle Triangle that returns the Angle in degrees of "A" knowing the Hypotenuse "c" and Height "a". I tried...

Hi hodkd, Try this: =IF(AND(F202000,H2075,H2086),D8,"") Biff -----Original Message----- I want to use a table to reference a cell if two other