+ Reply to Thread
Results 1 to 2 of 2

Find a value in the table cell

  1. #1
    Jiri
    Guest

    Find a value in the table cell

    What formula I should use to find a value of a specific cell in a defined
    rectangular database table by a reference to the row ID (text) and the Column
    ID (number)?

  2. #2
    Max
    Guest

    Re: Find a value in the table cell

    VLOOKUP would be one way ..

    Try Debra Dalgleish's nice coverage at her page:
    http://www.contextures.com/xlFunctions02.html
    (there's a sample book for d/l there)

    Another way would be to use INDEX / MATCH
    which Debra also covers at her:
    http://www.contextures.com/xlFunctions03.html
    (a sample book for d/l is available as well on the page)
    --
    Max
    Singapore
    http://savefile.com/projects/236895
    xdemechanik
    ---
    "Jiri" <[email protected]> wrote in message
    news:[email protected]...
    > What formula I should use to find a value of a specific cell in a defined
    > rectangular database table by a reference to the row ID (text) and the

    Column
    > ID (number)?




+ Reply to Thread

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