+ Reply to Thread
Results 1 to 6 of 6

Automatic list for recognizing input

  1. #1
    Registered User
    Join Date
    10-23-2019
    Location
    Athens
    MS-Off Ver
    365
    Posts
    28

    Automatic list for recognizing input

    Hi,

    I work in a hotel and we have 288 rooms. I made an excel sheet with in one column a list of the rooms (from 1 to 288) , a second column with the room type (for example Double, or Family, or Suite) and a third column with so next to each room number it shows whether the room is new or old.

    Now I want to make a cell where if I input manually the room number (for example 101) to have another cell automatically show me the room type and another cell showing if the room is new or old!

    Can someone assist?
    Attached Files Attached Files
    Last edited by Arismac74; 01-31-2020 at 07:37 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,602

    Re: Automatic list for recognizing input

    You can use a VLOOKUP formula. As you have not told us which cells or columns you are using for your data, I am not going to guess these and so cannot suggest the actual formula to use.

    Attach a sample workbook, as described in the yellow banner at the top of the screen.

    Pete

  3. #3
    Registered User
    Join Date
    10-23-2019
    Location
    Athens
    MS-Off Ver
    365
    Posts
    28

    Re: Automatic list for recognizing input

    Apologies, i have attached the book.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,602

    Re: Automatic list for recognizing input

    You can use this formula in F8:

    =VLOOKUP(F$5&"",A:C,2,0)

    and this one in F11:

    =VLOOKUP(F$5&"",A:C,3,0)

    Note that the only difference is in the third parameter, which determines which column of the table to return the data from.

    Hope this helps.

    Pete

  5. #5
    Registered User
    Join Date
    10-23-2019
    Location
    Athens
    MS-Off Ver
    365
    Posts
    28

    Re: Automatic list for recognizing input

    Thanx, exactly right!

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,602

    Re: Automatic list for recognizing input

    Glad to help, and thanks for the rep.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. New Web Query not recognizing tables from URL for automatic refresh
    By pidnani in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2015, 12:12 PM
  2. create a "live" input table for product prices from a list of automatic unique values
    By andymcnichol in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-11-2012, 06:13 AM
  3. Automatic Formula Input Based on User Input Using a Macro
    By Drayloc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2012, 12:10 PM
  4. vba recognizing original input
    By firefightnlife in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2012, 12:44 PM
  5. Automatic tracking number input using barcode input...
    By garyk76 in forum Excel General
    Replies: 0
    Last Post: 12-09-2011, 11:15 AM
  6. Sorting by recognizing values in a list
    By alexander.aberg in forum Excel General
    Replies: 2
    Last Post: 02-06-2011, 10:05 AM
  7. Excel not recognizing date input
    By xaver in forum Excel General
    Replies: 3
    Last Post: 09-23-2008, 08:14 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1