General

Need help with vlookup nested function
Hello, I need help with creating a vlookup nested function using the following logic: IF A2=R1 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER01 Interfaces'!$P$3:$Q$5001,2,FALSE) OR IF A2=R2 then VLOOKUP(B3,'[MTN_IPBH_M40E_Capacity_Tool.xls]ER02 Interfaces'!$P$3:$Q$5001,2,FALSE) Any help would be mu... 11 Jul 2008 10:58

File formats : XLSB versus XLSM
If you were to suggest a standard for other users to follow, would you pick one over the other? Why? Can anyone really see a performance benefit using XLSB over XLSM? I have found that XLSB saves the same file using less space than XLSM. What has been your experience? thanks, DSH ... 7 Jul 2008 14:33

How do I enter a Hard Return inside a cell?
I know I found this information once but cannot seem to be able to find it again in Excel Help. ... 8 Jul 2008 10:01

Close vs. Exit in 2007
I noticed that the two "X" in the upper right corner don't act the same. Formerly the upper buttons closed all of excel and the lower buttons closed only the active workbook. Why won't excel close when I hit the upper "X"? How can I change this option? ... 7 Jul 2008 16:38

Is there a button to close multiple files simultaneously
Is there a button in excel which I can use to close/save multiple files (worksheets)simultaneously? ... 7 Jul 2008 16:38

Is there a way to scroll (w/mouse) when entering a formula in 07
When entering a formula in Excel 07 I can't seem to scoll with my mouse anymore as I used to in previous versions. Is there an option I need to adjust? Thanks, Dustin ... 7 Jul 2008 14:33

Strange Message when opening workbook
When I try and open an excel workbook file this message pops up... The information you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook? -To update all linked information, click Yes. -To keep the existing informati... 7 Jul 2008 17:39

Excel Issue
after opening an excel document sent to me via email or network share I do not see any date in the individual cells but I do see the data in the formula bar? Any thoughts? ... 8 Jul 2008 13:06

Email notification of answer posted
I've been having the same problem for a long time and accidently just stumbled upon an answer. Although those links are to the right place, one needs to be logged on to the site in order for them to work. If you go to the Communities site first and log on then the link will open properly. I'm wondering if using... 7 Jul 2008 14:33

Choosing multiple items in a drop down list
Debra: I was able to use the macro that you supplied to be able to use both single select and multi select drop down lists within a worksheet. What if I want to incorporate several multi-select drop down lists within one worksheet? How do I need to adapt your macro? Much, much appreciated!!!! "Debr... 7 Jul 2008 14:33