Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: VLOOKUP and LOOKUP Problem

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Venezuela
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am triying to use these functions to look for a value inside a table, when I just finished the writing of the formula all is OK, but if I try to modify the original formula the cell which contains the formula become as a text value, I mean, that the formula stop its function. The only interesting detail that I Would like to comment is that the table has 9000 rows, probably this formula does not work with a huge table like this.
    Please suggest a solution

    Thanks

  2. #2
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can you post your formula and examples of your table?

  3. #3
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    816
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    VLOOKUP is function
    =VLOOKUP(value,array,column,boolean) is a formula.

    We need to see your formula to try to help you.


    Suat

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-23 14:30, jborges wrote:
    I am triying to use these functions to look for a value inside a table, when I just finished the writing of the formula all is OK, but if I try to modify the original formula the cell which contains the formula become as a text value, I mean, that the formula stop its function. The only interesting detail that I Would like to comment is that the table has 9000 rows, probably this formula does not work with a huge table like this.
    Please suggest a solution

    Thanks
    Is it possible that you formatted the cell containing your formula (perhaps, even the entire row or column) as Text after the formula was entered. If so, re-editing the formula will cause it to adopt the Text formatting and be displayed as "=VLOOKUP(...".

    If this is the case apply a General format to those cells before you edit any more formulas. You'll have to re-edit those that you inadverantly changed to restore the functioning of the formula, or you could select these cells and replace = with =.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •