+ Reply to Thread
Results 1 to 2 of 2

What function to use to search a table?

  1. #1
    Registered User
    Join Date
    11-03-2007
    Posts
    1

    What function to use to search a table?

    I am creating a mobile tariff checker (tool to find a cheapest mobile phone tariff with the most features).

    I have a table like below

    Tariff Name Tariff Name Tariff Name etc
    Network
    Contract Length
    Minutes
    Texts
    Data

    I need to search the table for all the options, i have a entry worksheet like below

    Enter Minutes
    Enter Texts
    Enter Data
    Enter Network
    Enter Price

    I would like the user to be able to input the above items to get a list of suitable tariffs and what they offer.

    What function(s) would in need to use? Any help is must appreciated.

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    VLOOKUP function may be used, however you need to provide a sample data in zip format for implementation of the function.

+ 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