Results 1 to 6 of 6

Conditional IF to be used for filling in Text

Threaded View

  1. #1
    Registered User
    Join Date
    01-01-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Conditional IF to be used for filling in Text

    I use Excel 2007 as way of entering my job quotes for a large number of clients. In order to speed the process of order entry, I would like to be able to simply select a specific customers account number from a drop down list and have the remainder of that customers information propogated to the various cells on the page based on that one specific cell.

    I'm using two worksheets for this purpose, the main worksheet contains the quote I am building and the other worksheet is the client database containing all the various information, account number, name, address, phone number etc.

    So the formula in WORDS would be something like;

    If Cell A2="Acct XYZ", then Cell B2="CompanyName for Acct XYZ" and Cell C2="Phone No. for Acct XYZ" and so on.

    I've gotten the formula to this point;

    =IF($A$2=Customers!$A$5, Customers!B5) Company Name

    =IF($A$2=Customers!$A$5, Customers!C5) Contact Name

    =IF($A$2=Customers!$A$5, Customers!D5) Phone Number

    and so forth.

    But of course this formula only works for the one client who happens to be on line A2 of the Customer worksheet.

    I need the formula to be dynamic so that it doesn't matter which Account Number I select from the drop-down list, it will always look to the cells to the right of that specific customer and find the appropriate data. (My Customers Data Information Worksheet is pretty simple, the first cell contains their Account Number and all their additional data is to the immediate right, therefore each line of the worksheet is one customer)

    I've attached a small data file with sample data
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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