nesting

  1. K

    Using an array as "find_text" in a FIND formula / or kind of a reverse VLOOKUP

    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...
  2. gmaboing

    URGENT: Need help with data validation and nesting if statements

    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...
  3. S

    VLOOKUP plus (nesting?) LEFT

    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...
  4. D

    Nesting IF statements, involving dates

    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...
  5. J

    nesting "IF" statements problem

    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...
  6. L

    Vlookup nesting

    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...
  7. M

    Viewing Nested XML in Excel

    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...
  8. D

    Trying to vlookup to move than 7 spreadsheets based on shipment type

    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...
  9. N

    HELP! Formula Nesting

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top