Vlookup (but the other way round)

silversurfer · Mar 19th, 2002, 07:20 AM

HI,

I know how to use Vlookup, but it is not working when my list in column 1 is actually shorter than the list with the lookup values.

Any advice?

Silversurfer

Dave Hawley · Mar 19th, 2002, 07:25 AM

Hi

Try INDEX and MATCH nested, eg

=INDEX(A1:E10,MATCH("MyValue",C1:C20,0),3)

Aladin Akyurek · Mar 19th, 2002, 08:16 AM

Quote:

On 2002-03-19 06:20, silversurfer wrote:
HI,

I know how to use Vlookup, but it is not working when my list in column 1 is actually shorter than the list with the lookup values.

Any advice?

Silversurfer

Care to provide a small sample that illustrates your problem?

Aladin

silversurfer · Mar 19th, 2002, 10:13 AM

Hi
The index and match solution worked!

Thanks very much

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

Mar 19th, 2002, 07:20 AM	#1
silversurfer New Member Join Date: Mar 2002 Posts: 4	HI, I know how to use Vlookup, but it is not working when my list in column 1 is actually shorter than the list with the lookup values. Any advice? Silversurfer

Mar 19th, 2002, 07:25 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Try INDEX and MATCH nested, eg =INDEX(A1:E10,MATCH("MyValue",C1:C20,0),3)

Mar 19th, 2002, 10:13 AM	#4
silversurfer New Member Join Date: Mar 2002 Posts: 4	Hi The index and match solution worked! Thanks very much