vlookup funtion is returning me #N/A but can I get this replaced with 0 or blank

I have a worksheet containing Customer feedback data which I continually add to. This is structured by employee, data, comment and so on. I want to be able...

Dear all, I have a pivot table which gets data from a table in SQL server table. However, some rows are deleted permanently in the SQL table but if the field...

Hiding page breaks in excel 2007 is now a painful multi-step process that requires you to select the office button, hit "excel options," select the...

This formula works nicely as an array for counting the number of values. =COUNT(IF(('Enroll I'!$C$2:$C$2741=A4)*('Enroll I'!$H$2:$H$27410)*(YEAR('Enroll...

I am trying to do a COUNTIFS() function in which I need to compare the difference between two numeric cells in the same row. In my spreadsheet, column G and...

I have the following situation Column A Column B Column C M Project# R Project# M0001 ...

I need a formula to distribute 3 days per year evenly. I have a cell with the start date this include month, day and year. I want to distribute the day...

I have a worksheet with ~10 columns and a 1000 rows. In column F, I have a date that has a range of several years. In column H I have a value, which...

I am paid on the 15th of each month, my bills are spread throughout the month. I am trying to find a formula or system to automatically rank the payments as...

I have dates in cells A1, C1, and E1. Cell F1 = 1/1/2009. What formula can I use to find the maximum of cells A1, C1, and E1 IF AND ONLY IF the date is is...

Hello, There has got to be a name and a formula to do what I'm trying to do, I just know it! Hopefully one of you smart, helpful folks will be able to assist...

Hi. I've been having my employees use the track changes feature in MS Excel 2007; however when I go through to highlight the changes on my computer, it only...

I have the formula if($0$3=20,2) I want to over ride to equal 0 (zero) if cell D60 = N -- KK

I have the following formula: Schematic: (A+C+E) + 0,57(B+D) - 3,14d Excel: =(Sheet1!M3+Sheet1!O3+Sheet1!Q3)+0.57*(Sheet1!N3+Sheet1!P3)-3.14*Sheet1!F3

I have a if formula in a cell, but need to override it from another cell. what formula can I use. --

Why do the cells in Excel sometimes appear blank but in the function line it shows that it has info in it? -- Jennifer

I am trying to create a timesheet using "v" for one vacation day and "1/2v" for a half of vacation day. function to count so that the total be 11/2 (one and...

I am trying to lookup an exact value (1113) in one cell and one column. then move across the row to a different colunm to add the values in that column. If...

My Excel 2003 workbook includes the following sort of...