Results 1 to 11 of 11

I need help looking up a value in a row, and reporting the column title and the value

Threaded View

  1. #1
    Registered User
    Join Date
    06-29-2006
    Posts
    85

    I need help looking up a value in a row, and reporting the column title and the value

    I have a sheet I am working on, and I dont know how to look up by a row

    basically
    I need to Look at a known Row, find the Column that is populated with a number value, and then report the value in a cell at the top of the column and the # in the populated row


    Link to the Document:

    *Link Removed because somebody else posted the file for me a couple of posts down*


    when you donwload it...

    the formula will end up in cells on Page "NC-40"

    I want to look at a row on Page "Input List" that matches the vale in the upper left corner of each box
    meaning the Box labeled 1, would look at "input list" Row 4
    then it would look for a value in E4 thru N4
    it would find that a value of "1" is in Cell E4 and would report "Brown 1" in the cell I pick on the NC-40 Page

    Even more ideal...if its possible to do this...
    it would just report the value "1" and change the Cell to the color in the row(meaning the formula cell would change itself to match the Brown Color)

    thanks if you can help...
    I'm currently baffled by how to make this work.
    Last edited by soundengineer; 01-27-2013 at 01:24 AM.

Thread Information

Users Browsing this Thread

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

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