Why when using a V Lookup do I get the result from the row above that required? =VLOOKUP("Greater London",range1,2,0) The answer should be 29 but I am...

Hi Maybe I'm going about this the wrong way but am trying to get results from a competition showing name place and score (top 3 only) onto a seperate...

Every tenant gets one free go per week. I need to create a formula where where any negative numbers are returned as a '0' result....

Hi there, I am using the following formula (see below), but wondering if the sheetnames I enter have to be in the EXACT order that there are in the...

Hello, I have designed a workbook containing many drop windows. Other people use this book. It contains 31 sheets (one for each day of the month). The...

Hi All How do I include Four criteria cells to determine the row and one criteria cell to determine the COLUMN to find a specific cell value? e.g Sheet One...

I have a spreadsheet with the following data, what I would like to do is: 1. sort this in descending order by number of sales (got the macro doing this) 2....

What is the the index of the name of the tab? Who can I get the tab name autmatic to a cell or the other way around? It will be nice to type a name once - no...

Hi MS Office Help, I would like to know how to choose a selection of cells based on what month it is in the real world. For instance, if the...

I would prefer to use a wildcard for text criteria in sumproduct counting and adding equations. I have tried versions of "*ABC*" and get false values.

A B C D A1 10 A2 9 1 A3 8 2 1 A4 7 3 2 A5 6 4 3 1 I need to calculate the differences of each value in a column and have...

What function would I use to add a range of numbers that includes a combo box? I tried AutoSum but the Total doesn't recalculate when I change the number in...

I am trying to complete a formula that will enable me to do the following. D4 = C3 + C4 D5 = C4 + C5 So the total in the D columnis the addition of the new C...

Hey guys. I want to make a sheet that has a cell in it where I use a barcode scanner to grab a barcode. What I want is for the cell to grab the barcode,...

I'm trying to come up with a formula to check if this is true in column A AND that is true in column B then SUM column C for corresponding rows. Here's part...

I have a column of data with number answers and blanks. The numbers vary slightly between 9 to 11, with no answers or zero's for some rows. I only want to...

Working in 2003, but this workbook has to also work in 2007 For this project I have to avoid macros because users are remote and may not enable macros. I...

Can Data Validation return a value to a second cell from an adjacent column in the list as well as the first cell when validation criteria is set as list? --...

I have a standard template for all tabs in one workbook (there are about 100 different tabs). What is the function to sum the same cells in each tab and...

So as I work with this VBA from coder I see you can set case of string Is there anyway to examine case? Either If All Uppercase or if Mixed/Init Caps is fine...