Can someone advise why this formula returns a "0" and not a blank? =IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE)) Thanks.

Hey is there a way to generate random numbers like you would for a draft. In other words, i have numbers 1 through 10 and generate a random order for those?

Ho do I hide multiple rows under one row in excel ? How do I see agan multiple rows hidden under one rwo ?

I am using Excel 2007. I have a large workbook (assembled from many sources) that contained many unused custom cell styles. I was able to delete all of the...

I would like to be able to conditonally hide row based upon a value in a column of the spreadsheet. I assume I would need to create a macro, but I'm nt real...

I love conditional formating but it allows only 3 different colour coding. I need to set up: 1) 10 different colour coding (possibly using VBA, but dont know...

I have an excel spreadsheet with teachers names, etc. How can I remove all the page breaks from the document at one time.

I had been playing with some macros in a book I have. I didn't think I had saved any of them. Now when I open that workbook, I get a message that says...

I have a text formula in one worksheet, adding the text of three cells together into one cell. i would then like to copy the resulting text into another...

No matter how I enter a function, it displays as text in the cell and doesn't perform the calculation. How can I enter a simple formula and have it display...

Hi. I have a shared workbook that is used by two processors. On column A I have a drop down that allows the processors to select Yes or No. I would like the...

I want to add 100 calendar days to a date in a cell and when that date falls on a weekend or holiday the formula will return the next workday vs. returning a...

okay. So I am trying to workout a formula to compute a commision earning. Basically, if X amount of new business is made, then X*Y (corresponding Commision...

I have a spreadsheet that has the following: A B C Start Time Run Day Run...

Hello, I have a challenging pivot table issue that I hope I can get some help on. Here is the spreadsheet I'm working...

Site for some reason, and forbidden http://downfree.zymichost.com/free

Ex: 11.2101.1030.0000.0000.1982 how can I remove these dots in multiple numbers on a spreadsheet?

I have a worksheet with the following data which are all results of formulas in each cell. On another worksheet, I need to sum all the amounts in Col C if...

I have a list of dates with various numbers listed as the day (03/25/2009, 04/05/2010, etc.) I need a formula to change all of the dates to display 01 as...

In the source sheet COL AB = recent cost COL W = latest purchase date (format mm/dd/yyyy) COL A = Part number I need to identify the latest cost of each...