Results 1 to 4 of 4

Thread: Copying data based on selected text

  1. #1

    Copying data based on selected text



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all

    Your help here would be greatly appreciated.

    Excel 2010.

    I have an inventory list on the first sheet with different rooms in a column. This room is taken from a list to avoid being spelled incorrectly.

    I am trying to make a "report" sheet (sheet 2) in the same workbook, to take information from the inventory list based on the room number selected in sheet 2.

    This is an example of the formula I did for the first room, which WORKED. Any other room I select does not work and the report page stays empty. Any time I select the first room it displays only the inventory for this room as I expected all of them to do.

    =IF(Table1[@Room]=Report!$F$3,Table1[@[Item Name]],"") where F3 is the location for the room name and Item Name is the name of the column for the data required.

    Please advise what I have done wrong?

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    quick look I'm guessing that the room may have a space in the name try add single quotes around it

  3. #3
    Hi Wizzard, thx for the reply but there are no spaces in the names.

  4. #4
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Are you coping the formula down? Change report!$F$3 to report!F3

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •