+ Reply to Thread
Results 1 to 4 of 4

Return the value of a cell from different sheet if the criteria is met

  1. 08-08-2015, 04:29 PM #1
    roshanrocks
    roshanrocks is offline
    Registered User
    Join Date
    08-08-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Return the value of a cell from different sheet if the criteria is met

    Hello Everyone,

    I am trying to solve this from a while and couldn't figure it out, so i thought to ask for some help.
    This is an excel spreadsheet for a hotel's reservation, with the availability. I would like the cell to show the name of the guest, which is on a different sheet but only if the criteria is met. For example, Booking a room for the date of August 10, 2015 - August 11, 2015, the cell turns red, meaning occupied, which is fine. But I would also the name of the guest in that red cell.

    I am attaching the file, any help will be great.
    Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-08-2015, 04:38 PM #2
    gmr4evr1
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Return the value of a cell from different sheet if the criteria is met

    Removed my post. I found the answer I was looking for
    Last edited by gmr4evr1; 08-08-2015 at 05:44 PM. Reason: Clarification
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom
    Reply With QuoteRegister To Reply
  3. 08-08-2015, 05:07 PM #3
    roshanrocks
    roshanrocks is offline
    Registered User
    Join Date
    08-08-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Re: Return the value of a cell from different sheet if the criteria is met

    No I havent?
    Why did you tag it as removed?
    Reply With QuoteRegister To Reply
  4. 08-10-2015, 02:17 PM #4
    roshanrocks
    roshanrocks is offline
    Registered User
    Join Date
    08-08-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    3

    Re: Return the value of a cell from different sheet if the criteria is met

    Can someone please help me?
    Thanks.
    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. [SOLVED] Return the value of a cell based on 4 criteria
    By rossi_69 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-24-2015, 03:03 PM
  2. [SOLVED] Filter single criteria across all worksheets and return values to a summary sheet
    By shreeja178 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-30-2014, 10:05 AM
  3. [SOLVED] Return a value:index/match against multiple criteria on another sheet
    By Southfish in forum Excel General
    Replies: 3
    Last Post: 04-30-2012, 11:08 PM
  4. Return text in cell if certain criteria is met?
    By bbdallas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2007, 11:56 PM
  5. Return a value if criteria contained in cell
    By jhicsupt in forum Excel General
    Replies: 7
    Last Post: 10-05-2005, 05: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1