VLOOKUP and LOOKUP Problem

[jborges]

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

 

[Brian from Maui]

Can you post your formula and examples of your table?

 

[smozgur]

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

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

 

[Mark W.]

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 =.