Results 1 to 5 of 5

Nested Vlookups and If Statements

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2012
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Nested Vlookups and If Statements

    Hello,

    I am looking to write a formula that does three things:

    1. Vlookup that checks list A for an amount - returning amount if listed
    2. Vlookup that checks list B for an amount - returning amount if listed

    If my reference isn't in either list I want excel to complete an if statement to perform a calculation.

    3. If Statement to complete a cacluation


    Example attached.

    Thanks for your help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Nested If and Vlookups
    By lorber123 in forum Excel General
    Replies: 4
    Last Post: 05-18-2014, 12:48 PM
  2. [SOLVED] Nested IF statements that involve #N/A errors from vlookups
    By CorporateBatteryHen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-02-2013, 02:03 AM
  3. Adding ISNA to long nested IF statements with vlookups
    By vgately99 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-07-2013, 02:59 PM
  4. Nested Vlookups?
    By tenscourts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2012, 06:03 AM
  5. Nested if statements with vlookups
    By txbullets in forum Excel General
    Replies: 4
    Last Post: 12-08-2011, 10:30 AM
  6. Nested IFs and VLOOKUPs
    By Johny1 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-26-2009, 07:11 AM
  7. Nested Vlookups
    By TarekHamouda in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-12-2006, 02:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1