Results 1 to 14 of 14

Find a specific date within a table and return value is specific column in the same row

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2023
    Location
    California
    MS-Off Ver
    365
    Posts
    7

    Find a specific date within a table and return value is specific column in the same row

    Hello,

    I am trying to avoid multiple if, and statements in a project I am doing. What I have is a table of dates in C2:Q31. I am looking for a formula that would find a specified date within the table and return the date in column Q within the row the date is found. I tried VLookup and is only looking for the date in column C and not columns D through P. Any suggestions would be very much appreciated.

    Thank you!
    Attached Files Attached Files
    Last edited by NatalieCox; 03-15-2023 at 02:52 PM. Reason: Attaching Sample

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find a specific number in a large table of numbers and return where it is
    By Thomaswharper in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-16-2020, 01:20 PM
  2. [SOLVED] Find duplicate return specific column color
    By MaKo82 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-19-2019, 11:48 AM
  3. [SOLVED] Find the last specific value in a column and return the adjacent value
    By zeegerman in forum Excel General
    Replies: 4
    Last Post: 08-03-2015, 11:55 AM
  4. [SOLVED] Find specific value in table and return header row and header column value
    By nelwan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2013, 01:35 AM
  5. [SOLVED] Return a specific value for a date from a table of date ranges
    By Brit in forum Excel General
    Replies: 3
    Last Post: 07-11-2012, 05:53 AM
  6. Find specific text in column and return cell value from its immediate right
    By cneff in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-08-2012, 07:59 AM
  7. Replies: 1
    Last Post: 01-15-2010, 05:29 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