Results 1 to 5 of 5

Find a value in a list and show a corosponding value

Threaded View

  1. 05-25-2017, 09:06 AM #1
    muss1210
    muss1210 is offline
    Registered User
    Join Date
    04-18-2017
    Location
    NW,UK
    MS-Off Ver
    MS Office 2013
    Posts
    89

    Find a value in a list and show a corosponding value

    Hello All

    I have the below data and I would like code to look in cell B1 (19)find the number in column C (19) then find the corresponding letter in column D (G) and return the value in cell E1 (G).

    B      C      D      E

19	17	E	G
	18	F	
	19	G	
	20	H	
	21	I
    thank you in advance
    Last edited by JBeaucaire; 05-25-2017 at 10:51 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Show list of name selected on list of box in userform
    By mazan2010 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-14-2017, 10:27 AM
  2. [SOLVED] Dynamic Combobox List Won't show Any List (Adapt from Contextures) Help!
    By radian89 in forum Excel General
    Replies: 5
    Last Post: 04-09-2016, 12:33 PM
  3. In-cell drop down list, show from one list but output from another?
    By ppgab in forum Excel General
    Replies: 1
    Last Post: 03-02-2015, 09:04 AM
  4. Excel Drop Down Menu - Select List Item - (Show Data Associated With That List Selection.)
    By meppley7 in forum Excel General
    Replies: 5
    Last Post: 04-11-2014, 03:13 PM
  5. Way to filter an RSS feed vs a list and show only values not in that list?
    By regrahc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-23-2013, 02:15 PM
  6. sort field number to corosponding tally in a different xls name
    By jafooli in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2012, 11:36 AM
  7. drop list matching corosponding values from another set of cells or tab
    By dravenb4u in forum Excel General
    Replies: 5
    Last Post: 09-26-2008, 02:08 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1