+ Reply to Thread
Results 1 to 2 of 2

Control Formating from one cell to another celll in workbook

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    2

    Control Formating from one cell to another celll in workbook

    Fairly new at Excel 2007. I need help with this issue and need help on how to imploment the control. I have 2 sheets in my workbook. On sheet 2 is my control information. On sheet 1 is my control. I have cell A1 set up as a "Data Validation" "In-cell dropdown" taking 10 values from sheet 2 cells A1-A10. Is there a way that I can get cell A2 on sheet 1 to take corisponding infromation from cells B1-B2 on sheet 2 to auto fill in cell A2 on sheet 1.
    Example:
    If A1(sheet1) is A1(sheet2) then A2(sheet1) is B1 or
    If A1(sheet1) is A2(sheet2) then A2(sheet1) is B2 or
    If A1(sheet1) is A3(sheet2) then A2(sheet1) is B3....... and so on.

    Thanks for the help.

  2. #2
    Registered User
    Join Date
    06-07-2012
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Control Formating from one cell to another celll in workbook

    I figured it out. Thanks to twiggywales and his formula. I just needed to adjust it to work for my workbook.
    =VLOOKUP($C4,Sheet1!B1:C10,2,FALSE)
    *Note: You must have False at the end for formula to work correctly.
    Thanks again twiggywales

+ Reply to Thread

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