simple vlookup question

[murdoc]

Hi.

I have a simple question i guess, please help:P

So i have a large data worksheet with first 8 columns of vlookups that looking for id on other page in col1 and results value from col 10.

vlookup(id;'Other worksheet' $A:$X;10;false)

In the next cell i have the same formula but it gets value from the next column for same id :
vlookup(id;'Other worksheet' $A:$X;11;false) (or + column())

and same for other 6 columns.

The question is, can i speed up my calculation by applying some other formula to get value for the next cell, when i already found ROWxCOLUMNxCELL, in the first vlookup?

Or do i actually need to use 8 vlookups?


Thanks a lot!

p.s. sorry for my english

 

[mole999]

$A:$X; is giving you 24 million cells to reference

if you limited to a named range of A*:X10000 you would cover off less

or you could look to an INDEX MATCH and just reference the Columns you need reducing from 24 to only 8

you are either looking for OFFSET or INDIRECT (not sure which is best for what you describe)

 

[murdoc]

$A:$X; is giving you 24 million cells to reference

if you limited to a named range of A*:X10000 you would cover off less

or you could look to an INDEX MATCH and just reference the Columns you need reducing from 24 to only 8

you are either looking for OFFSET or INDIRECT (not sure which is best for what you describe)

thanks to your reply!

actually i have something like A1:J3000, i wrote A:X as an example. I understand that lowering range makes vlookup faster.
But my question is more about an option to avoid vlookups in cells 2,3,4,5,6,7,8 when i already found rowXcolumn cross by vlookup in cell 1.

So that it can look something like:

A1 | A2 | etc. up to 18
vlookup(id;'Other Page' $A$1:$J$3000;10;false) | formula that gives value from (col 11)|


instead of:

A1 | A2 | etc. up to 18
vlookup(id;'Other Page' $A$1:$J$3000;10;false) | vlookup(id;'Other Page' $A$1:$J$3000;11;false))|




is it possible?

tnx

 

[Aladin Akyurek]

Which is the first cell you enter the vlookup formula you copy down? And what is that formula in that cell exactly?