how is v-lookup in ms excel done?

some times when I opeen excel file, it will close and restart

In Excel 2003 and 2007, why, when adding 664,199.05 and negative 582,911.61 the answer comes out 81,287.4400000001? Why is there a 1 at the end? This...

Thanks you Mike for reply it's working fine. Thanks Again. One more thing i am useing excel2003 is there any good book for excel2007 or any PDF file from...

Thank you for your reply. -- Thanks, Sharon "Jacob Skaria" wrote: Sorry, you cannot.

Hi, It depends on which version of Excel you have. E2003 Tools|Options|Error checking tab - Un-Check "Enable background error checking" E2007 Office...

So simple but I would never have got there. Thanks very much "Jacob Skaria" wrote: Hi Ben In F2 use the formula and copy down ...

ActiveWorkbook.SaveAs Filename:="C:\Filename.dat"_ , FileFormat:=xlText, CreateBackup:=False "Mia" wrote: Hello, I have a problem. I need to...

Hi I want to be able to put say the letter A in column A-1 but want a formula that wil also put the same letter A in like 6 more times for instance B-2, C-3,...

Not sure if it will fully works. Note that my assumption is that a similar weight amount will not occur more than twice, otherwise, the formula definitely...

Thanks for getting back so soon, however I don't want to replace the dash, I want to delete any rows where the 3rd character = "-" -- Randy "Jacob Skaria"...

=SUM(IF('Day 1'!$C$4:$C$37=A22,'Day 1'!$D$4:$M$37))+SUM(IF('Day 2'!$C$4:$C$37=A22,'Day 2'!$D$4:$M$37))+SUM(IF('Day 3'!$C$4:$C$37=A22,'Day...

I am hoping to automate the extraction of information from a series of workbooks submitted by staff each week into a main spreadsheet. The importing...

Karl Put this formula in all the cells you want to match your input cell. In this case A1. =A1 Now when you enter anything into A1 it will show up in all...

Check your other posts in the below links for...

I want to lookup a date from a workbook to add to a specfic cell in another workbook, can this be done? I've tried a vlookup but this would mean that I will...

I'm trying to have conditional formatting for more than 4 conditions. I'd like to use the VBA code, but I'm not sure where I enter the conditions in the...

Hi, I wouldn't let them anywhere near it because if you do it will end in tears!! Lets say you 6 segment numbers are in column A. Protect that column so it...

I'm hoping somene can help me with my problem. I have few thousand rows of data we create a large report from each month in Excel. We have now been asked...

How do you compare 2 excel documents with track changes and merge them together after accepting the changes in Excel 2007?