VLOOKUP and LOOKUP Problem

jborges · Apr 23rd, 2002, 03:30 PM

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 · Apr 23rd, 2002, 04:39 PM

Can you post your formula and examples of your table?

smozgur · Apr 24th, 2002, 09:21 AM

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

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

Mark W. · Apr 24th, 2002, 09:28 AM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 03:30 PM	#1
jborges New Member Join Date: Apr 2002 Location: Venezuela Posts: 13	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

Apr 23rd, 2002, 04:39 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Can you post your formula and examples of your table?

Apr 24th, 2002, 09:21 AM	#3
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	VLOOKUP is function =VLOOKUP(value,array,column,boolean) is a formula. We need to see your formula to try to help you.