Re: formulas between sheets

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Good eyes Max.

AJ was overlooked by yours truly.

I guess that was the "something else" that was going on<g>


Gord

On Fri, 8 Sep 2006 15:46:24 +0800, "Max" <demechanik@xxxxxxxxx> wrote:

Some thoughts on your orig. post ..

this formula works "=VLOOKUP($I$4,'Data Entry'!$A:$AJ,36,FALSE)"
but when the 36 is changed to any higher number it does not work.

That's because the table array 'Data Entry'!$A:$AJ covers cols A to AJ only,
a total of 36 cols.

"=VLOOKUP($I$4,'Data Entry'!$A:$AJ,37,FALSE)".
is 36 the max number of 'lookups' i can have?

Just extend the table array to say: 'Data Entry'!$A:$BZ and it'll work till
78
Eg: =VLOOKUP($I$4,'Data Entry'!$A:$BZ,37,FALSE)

Or, go the full show to cover all 256 cols, viz use:
=VLOOKUP($I$4,'Data Entry'!$1:$65536,37,FALSE)

.

Quantcast