Results 1 to 3 of 3

Populating a table on another sheet - reference 1 cell, return another

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2016
    Location
    Savannah, Ga
    MS-Off Ver
    2016
    Posts
    17

    Populating a table on another sheet - reference 1 cell, return another

    Hello and thank you for the assistance here.

    I've seen several formulas for what I want to do which look close but I can't seem to get them working.

    Here's what I've got:
    Sheet 1= IP Scheme
    Sheet 2= Cameras

    I have a master list on Sheet 1 of all devices located at a site, from that list I want to auto-populate another sheet for each device type (Camera, Radio, Access Control, ect.)

    I have all of my information in tables:
    IP_Scheme - the columns in question are called [IP Address] and [Device Type].

    Starting on A22 in 'Cameras' I need to be able to pull in the ip address of ONLY the devices that are labeled as a "Camera" in the [Device Type] column. I want no blanks along the line. From there I can just use INDEX to pull the information I need in the other cells. My problem is the counting to make the formula move down the list and return each IP in order down the IP list that is tagged "camera"

    Any help is much appreciated. I've attached an example sheet for reference.
    Attached Files Attached Files
    Last edited by tweaver; 01-13-2016 at 03:36 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Cell and Sheet Reference/Return
    By Barb R. in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 12:05 PM
  2. [SOLVED] Cell and Sheet Reference/Return
    By Barb R. in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 07:05 AM
  3. Cell and Sheet Reference/Return
    By Barb R. in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 06:05 AM
  4. [SOLVED] Cell and Sheet Reference/Return
    By Barb R. in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 AM
  5. Cell and Sheet Reference/Return
    By Andrew in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. Cell and Sheet Reference/Return
    By Andrew in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] Cell and Sheet Reference/Return
    By Andrew in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. [SOLVED] Cell and Sheet Reference/Return
    By Andrew in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

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