+ Reply to Thread
Results 1 to 2 of 2

choose cell in column corresponding to cell next to it

  1. 11-01-2016, 11:30 AM #1
    bjcowen9000
    bjcowen9000 is offline
    Forum Contributor
    Join Date
    02-13-2013
    Location
    Columbia, SC
    MS-Off Ver
    Excel 2010
    Posts
    217

    choose cell in column corresponding to cell next to it

    Hi in cell K11, I want to reference and the value in column D that is equivalent to my value is J11.

    Then if say for example, the value that matches is D4, I want E4 to go into cell K11.

    Is this possible?
    Reply With QuoteRegister To Reply
  2. 11-01-2016, 11:36 AM #2
    Olly
    Olly is offline
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: choose cell in column corresponding to cell next to it

    Try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Select Cell using a Letter from another sheet as the column to choose
    By MariaD89 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-23-2016, 03:18 PM
  2. Choose a cell based on another cell?
    By Jaxxs in forum Excel General
    Replies: 6
    Last Post: 03-28-2012, 03:42 AM
  3. Formula to choose next cell down if text already in cell
    By [email protected] in forum Excel General
    Replies: 6
    Last Post: 05-13-2010, 11:02 AM
  4. How can I make sure that I choose only one cell per column?
    By Advice Pro in forum Excel General
    Replies: 4
    Last Post: 03-27-2009, 06:53 PM
  5. [SOLVED] Formula to choose cell and then cell three rows down
    By mg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-01-2006, 01:55 PM
  6. How to indicate in formula to choose the entire column starting from a specified cell?
    By [email protected] in forum Excel General
    Replies: 3
    Last Post: 06-12-2006, 11:30 PM
  7. Choose:HD I build funct @if cell=AorBorC then ...else if cell=DorE then
    By KL in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 09-06-2005, 04:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1