+ Reply to Thread
Results 1 to 5 of 5

Trying to formulate Column E with result due to selection from Column D

  1. #1
    Registered User
    Join Date
    12-28-2015
    Location
    KL
    MS-Off Ver
    2013
    Posts
    47

    Trying to formulate Column E with result due to selection from Column D

    Dear All,

    I am trying to work to formulate column D to reflect an answer when a selection made on column C.
    For e.g., When i select 1(column C), column D will reflect Low+Green color.
    As for the color i guess, i will have to do conditional formatting, however, when i make selection the file reflects as #N/A.

    Formula used : =IF(ISNUMBER(FIND($D11,"1 2 3",1)),VLOOKUP(TRIM($D11),Code!$B$1:$C$3,2,FALSE),"")

    I have attached my excel, appreciate if anyone can be an assistance for me.
    Also, kindly refer to tab code for the drop down option.

    Many thanks guys,

    Regards,
    Steve
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,927

    Re: Trying to formulate Column E with result due to selection from Column D

    Try

    =IF(ISNUMBER(FIND($D11,"1 2 3",1)),VLOOKUP($D11,Code!$B$1:$C$3,2,FALSE),"")
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You were using Trim function with is only for text not for numbers.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,896

    Re: Trying to formulate Column E with result due to selection from Column D

    =IFERROR(VLOOKUP(TRIM($D11)+0,Code!$B$1:$C$3,2,FALSE),"")
    Please Login or Register  to view this content.
    try this formula
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Registered User
    Join Date
    12-28-2015
    Location
    KL
    MS-Off Ver
    2013
    Posts
    47

    Re: Trying to formulate Column E with result due to selection from Column D

    Mate, Thank you so much for your kind assistance. I have rectified the problem now. Many thanks again.

  5. #5
    Registered User
    Join Date
    12-28-2015
    Location
    KL
    MS-Off Ver
    2013
    Posts
    47

    Re: Trying to formulate Column E with result due to selection from Column D

    Thanks so much Siva for your kind assistance. I do sincerely appreciate your help as well. Have a great day ahead and Happy New Year to you both.

+ 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. Formulate multi results on seperate column
    By seaton in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-30-2013, 06:07 PM
  2. Ping Host Name Column A IP address Result column B Response time Column c
    By NickMac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2012, 03:23 AM
  3. Replies: 7
    Last Post: 09-02-2011, 04:26 PM
  4. How to formulate character in a column?
    By greenbirdcity in forum Excel General
    Replies: 3
    Last Post: 11-03-2008, 08:13 AM
  5. How do I formulate a high price column
    By Lou New At Excel in forum Excel General
    Replies: 1
    Last Post: 04-17-2006, 08:35 PM
  6. [SOLVED] How do you formulate an entire column?
    By SWcoord in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-15-2006, 02:45 PM
  7. Formulate a Column ?
    By NT_eyeball in forum Excel General
    Replies: 2
    Last Post: 08-15-2005, 11: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