+ Reply to Thread
Results 1 to 4 of 4

Link and display two different columns

  1. #1
    Forum Contributor
    Join Date
    10-09-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    120

    Link and display two different columns

    Hello All, thank you first of all for all the help! Love this forum, people are so responsive and helpful. I'm learning from everyone. New question - The Customer column populates from a pull down list and can be updated on the fly using a nice macro you all provided. But now I have to give the Customer a ranking letter A, B, C etc and have that populate in the Ranking column when Customer is selected. However, I still want to be able to populate on the fly for both Customer and Ranking but link them so if Customer Mohawk is selected it would display the ranking B.

    To further complicate this, the Customers automatically sort Alphabetically so the Ranking letter would have to stay associated. Does that make sense?

    I've attached the file. Thank you again in advance for the help!
    Attached Files Attached Files

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Link and display two different columns

    Hi jmckeon,

    I assume this is to populate the QuoteLog sheet? paste the following formula in C3, and then drag down to copy it to the rest of the table...

    =IF(ISNA(VLOOKUP(B3,Lists!$B$1:$D$94,3,)),"",IF(VLOOKUP(B3,Lists!$B$1:$D$94,3,)=0,"",VLOOKUP(B3,Lists!$B$1:$D$94,3,)))

    The range of the lookup will not change dynamically this way, but it will pick up new ranks for existing listed customers. Is this what you intend?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Contributor
    Join Date
    10-09-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    120

    Re: Link and display two different columns

    Almost but want to be able to either pulldown a customer or add on the fly as it does now. It then will resort the customer names in Alphabetical order! That's great. Now I want to be able to associate a Ranking Letter with each customer and have that stay linked to the Customer name even if the list resorts. Is that possible?

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Link and display two different columns

    The lookup formula should find the customer wherever he is on the list, and find his ranking if there is one. The limitation of the formula is that it searches a static range (B1:D94) on the lists page. I suppose a named range would solve that, so long as the named range gets updated.

+ 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. Website Name = Display Link
    By MrBump87 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-27-2013, 06:21 PM
  2. Find and display the last occurance in two columns and display related cell
    By willia97 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-28-2012, 08:14 PM
  3. Display name of tab from a cell link
    By Silverscreen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-27-2011, 11:34 AM
  4. Display the complete URL instead of a link
    By Susan in forum Excel General
    Replies: 2
    Last Post: 11-23-2005, 11:35 AM
  5. [SOLVED] display text from a link
    By Ronald (Gmail) in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2005, 11:06 PM

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