Results 1 to 4 of 4

Table Array Search

Threaded View

  1. #1
    Registered User
    Join Date
    08-24-2006
    Posts
    48

    Table Array Search

    Hi:

    See attached image. If the end user puts in the year "1974", I'd like a function to search the entire table, reference whatever it finds in the same row, but always refer to column H. So, as per attached image, if end user put in 1974, the output would "Tiger." If someone entered 2006, the output would be "Dog."

    How would I write this function?

    Thank you!
    Attached Images Attached Images
    Last edited by ExcelJunkie; 10-11-2006 at 02:38 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