+ Reply to Thread
Results 1 to 9 of 9

Conditional Formula or Macro based on a range - help!

  1. #1
    Registered User
    Join Date
    03-03-2016
    Location
    austin
    MS-Off Ver
    2013
    Posts
    5

    Conditional Formula or Macro based on a range - help!

    Im a noob!!! Help

    On one sheet (Sheet 1) i have a data set of: column with a header of "Customers" with a range of Test Customer 1...13; column with a header of "Attention" with a range of Joe Test 1...13; column with a header of "Phone" with a range of 310-555-0001...0013; column with a header of "Address" with a range of Test 1 Street...Test 13 Street; column with a header of "City" with a range of City 1...13; column with a header of "State" with a range of Test State 1...13; column with a header of "Zip" with a range of 00001...00013

    On another sheet (Sheet 2) i have the same column headers. However, within the Customer column, each field in the column has a validation "key" (drop down menu) whereby i can typing the customer name and the list filters and ultimately my desired customer can be quickly selected before i have to type in the full customer name. Example, if i type '1', the list populates Customer 1, Customer 10, Customer 11, Customer 12 and Customer 13.

    I would like for the remaining cells in a row (to the right of the Customer column) to automatically populate the information associated with the customer selected, found on Sheet 1. So, if on Row 1, i select Customer 3, then the information for Customer 3 relating to Attention, Phone, Address, City, State and Zip found on Sheet 1 automatically fills in on Row 1 under the appropriate column on Sheet 2. If i select Customer 8 on Row 2, then all of Customer 8's info from Sheet 1 will fill in in the appropriate cells along that row on Sheet 2.

    Possible?!??!

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,105

    Re: Conditional Formula or Macro based on a range - help!

    Possible. Can you upload your sample workbook using 'Go Advanced' and the paperclip icon?

  3. #3
    Registered User
    Join Date
    03-03-2016
    Location
    austin
    MS-Off Ver
    2013
    Posts
    5

    Re: Conditional Formula or Macro based on a range - help!

    where is that option "Go Advanced" and the paper clip icon? i dont see that?

  4. #4
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,105

    Re: Conditional Formula or Macro based on a range - help!

    beneath the reply box. Under the various emoticons to the right.

  5. #5
    Registered User
    Join Date
    03-03-2016
    Location
    austin
    MS-Off Ver
    2013
    Posts
    5

    Question Re: Conditional Formula or Macro based on a range - help!

    i see it...but the paper clip doesnt allow me to upload anything!

  6. #6
    Registered User
    Join Date
    03-03-2016
    Location
    austin
    MS-Off Ver
    2013
    Posts
    5

    Re: Conditional Formula or Macro based on a range - help!

    i think now it uploaded...
    Attached Files Attached Files

  7. #7
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,105

    Re: Conditional Formula or Macro based on a range - help!

    Try putting the formula below in C3 of the results sheet, then fill right and down.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,105

    Re: Conditional Formula or Macro based on a range - help!

    This one will leave the cells in unused rows blank:

    =IFERROR(INDEX(Data!C:C,MATCH($B3,Data!$B:$B,0)),"")

  9. #9
    Registered User
    Join Date
    03-03-2016
    Location
    austin
    MS-Off Ver
    2013
    Posts
    5

    Re: Conditional Formula or Macro based on a range - help!

    awesome!!! thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting Based on Range
    By ExcelDavid in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-25-2015, 02:53 PM
  2. [SOLVED] Conditional Sum based on Date Range
    By atulexel79 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-05-2014, 09:28 AM
  3. Replies: 3
    Last Post: 08-13-2013, 09:44 AM
  4. [SOLVED] Macro to run formula based on a range of data in some rows of a column REVISITED
    By Pro Sherman in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2013, 11:32 PM
  5. [SOLVED] Macro to run formula based on a range of data in some rows of a column
    By Pro Sherman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2013, 02:33 PM
  6. 3+ Conditional Formatting Rules for cell range based on Formula from other cells
    By osborsm9 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-06-2013, 08:48 PM
  7. Conditional Formatting - Grey Out and Lock A range based on a cell value in that range
    By Excelgnome in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2012, 07:31 PM

Tags for this Thread

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