Results 1 to 5 of 5

Find a Value in Row and Reference a Cell in Same Column as Value

Threaded View

TylerJamison Find a Value in Row and... 08-13-2012, 06:18 PM
xladept Re: Find a Value in Row and... 08-13-2012, 06:32 PM
TylerJamison Re: Find a Value in Row and... 08-14-2012, 10:25 AM
TylerJamison Re: Find a Value in Row and... 08-14-2012, 11:17 AM
xladept Re: Find a Value in Row and... 08-14-2012, 11:44 AM
  1. #1
    Registered User
    Join Date
    06-26-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    36

    Find a Value in Row and Reference a Cell in Same Column as Value

    Hi there,

    What I'd like to do is find the value "H" in a series of cells (let's say F3:AC3, for example) and return the value (which is a date) from row 2 of that same column. For example, if there is an "H" (a code indicating that the crop has been harvested) in cell H3, I would like Excel to return the value that is in H2. This is easy to do once, but I need it to work automatically for hundreds of different crops.

    Any ideas?

    Thank you.
    Last edited by TylerJamison; 08-14-2012 at 11:17 AM.

Thread Information

Users Browsing this Thread

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

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