nesting

I am having an issue with getting a Pivot Table to display data how I would like to report on it. The column labels are fine, and when I put one field into the row label section, I see data how I would like to. When I add another field to the Row Label section, it nests this within the first...

This seems theoretically simple but I can't wrap my head around it: In A1 I have a text string, ie "Hello World!" I want to find "World" within the text string, as part of an IF(ISERROR...) formula: = IF(ISERROR(FIND("World", A1),"","Hooray!") Now, I want to find EITHER "Hello" or "World", the...

Need help with nesting and data validation BASIC BACKGROUND INFO: I have a spreadsheet that I am doing data validation with multiple dependent lists. I have setup a validation list for my first instance, and for my second instance, instead of using the 'Indirect()' command, I decided to do a...

I have a LEFT formula looking at the first 3 letters of Serial numbers. I have a second sheet with Locations that correspond to the first three letters of the serial number...So I have a column showing me the Abbreviation...then another column using a Vlookup to find the corresponding...

Trying to create a formula in AX4 that has the following criteria: Returns "Y" if Today's Date falls between the date noted in AV and the date noted in AW and AT is "NO"; "N" if Today's Date falls past the date noted in AW and AT is "NO"; "NA" if AT is a "YES"; and BLANK if nothing is entered...

Dear users, I am new to this forum and hope to get some help on the following and possible future problems. I have a problem nesting four "IF" statements into one function. The several other threads on this problem helped me to no avail. Here are my four statements...

I'm having trouble trying to use multiple vlookups together, which I don't even know is possible or not. Basically, I have a table that is exported from an application, so it's always the same, and copy/pasted into excel sheet over the previous day's table. The table has many locations and...

Hi, I am new to the forum...thought I was quite competant with Excel until I came across a whole new world of XML.... I understand the basics, however what I am trying to do is view XML that may have several nests within it, for instance: --> Customer Number, Name, Address etc --> --> Order...

Column A = Shipment Type (ie. NDA comm, NDA resi, NDAsaver, etc.) Column B = Package weight Column C = Package ship to Zone I am trying to create a spreadsheet that will look up princing based on both the weight and zone for shipping: =VLOOKUP(B2,'[UPSRates2008.xls]NDA...

Hello All, Thank in advance. I have 2 dropdowns (validation list). One dropdown contains a list of "first names" 10 of them, the second contains a list of "last names" 10 of them also. When someone chooses a combination of "john" and "smith" (for example) from the individual dropdowns then...