can any1 help me about this vlookup?

LMF · Apr 12th, 2002, 06:50 AM

i have used vlookup many times in one formula and is wondering if there is any alternative function that i can use to minise it.

anyone?

[ This Message was edited by: LMF on 2002-04-12 05:51 ]

[ This Message was edited by: LMF on 2002-04-12 05:51 ]

Andy Gee · Apr 12th, 2002, 07:37 AM

Not a lot of detail to go on, but, how about putting the vlookup in another cell then reference it from your formulae

Good luck

LMF · Apr 12th, 2002, 07:41 AM

but to be honest, that won't really make a difference will it?

how about using DGET or INDEX ???

does it work the same as vlookup?
or similar?

lmk

thanks

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

Apr 12th, 2002, 06:50 AM	#1
LMF Board Regular Join Date: Mar 2002 Posts: 73	i have used vlookup many times in one formula and is wondering if there is any alternative function that i can use to minise it. anyone? [ This Message was edited by: LMF on 2002-04-12 05:51 ] [ This Message was edited by: LMF on 2002-04-12 05:51 ]

Apr 12th, 2002, 07:37 AM	#2
Andy Gee New Member Join Date: Feb 2002 Posts: 48	Not a lot of detail to go on, but, how about putting the vlookup in another cell then reference it from your formulae Good luck

Apr 12th, 2002, 07:41 AM	#3
LMF Board Regular Join Date: Mar 2002 Posts: 73	but to be honest, that won't really make a difference will it? how about using DGET or INDEX ??? does it work the same as vlookup? or similar? lmk thanks