Results 1 to 8 of 8

Is there an easier way to do call up info then using a ton of nested IF functions?

Threaded View

  1. #1
    Registered User
    Join Date
    10-15-2015
    Location
    USA
    MS-Off Ver
    MS Office 2013
    Posts
    83

    Question Is there an easier way to do call up info then using a ton of nested IF functions?

    Here are the two sheets in question

    Instructions

    DATABASE

    So, here is what I'm trying to do. On the Instructions sheet, there is a drop down box that has all of the departments from the DATABASE sheet. You just select what dept a new a worker will be working in. What I would like to do is make it so that when you select a department from the drop down box, excel will fill in the rest of the information (phone number, address, manager and assistant mgr) using the corresponding info from the database.

    I know that I could do this with nested IF functions, you know for the Manager field, like:

    =IF(B2=DATABASE!F4, A4, IF(B2=DATABASE!F5, A5, IF(B2=DATABASE!F6, A6, IF(B2=DATABASE!F7, A7...)))))))))

    And that's just the manager one. I'd need a similar thing for the asst mgr, address, phone number and other stuff.

    I know I could do that and it would work. But I would also need to add an additional IF statement to the end every time I add another department to the database. I was hoping that there was an easier way to do this.

    EDIT: Ugh... I spelled "than" wrong. Probably because I had been writing "IF" so much...
    Last edited by TnD_Guy; 04-12-2016 at 11:05 AM. Reason: typo!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Easier Way To Decipher Nested Nested IF's
    By Vladamir in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-06-2015, 03:37 PM
  2. Must be an easier way then a Nested If....
    By jackfrostog in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-18-2013, 05:10 PM
  3. Easier way to call a range?
    By drcheaud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2011, 02:47 PM
  4. Nested IF (an easier way?)
    By LPH in forum Excel General
    Replies: 5
    Last Post: 03-21-2009, 08:07 PM
  5. Easier nested subtotals in Excel
    By Zsolt Dubovanszky in forum Excel General
    Replies: 2
    Last Post: 05-05-2006, 09:15 AM
  6. Please make it easier to access the IS functions (e.g., isblank) .
    By melyndac2005 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  7. Please make it easier to access the IS functions (e.g., isblank) .
    By melyndac2005 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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