RE: Vlookup with multiple variables

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mike H <MikeH@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 14 Aug 2008 11:02:02 -0700

Try this

=INDEX(A1:A10,MATCH(1,(B1:B10="value1")*(C1:C10="value2"),0))

where a1 - A10 is the value to return and the other 2 columns are the lookup
values

Mike

"Sam" wrote:

How do I do a vlookup which will match multple variables?

Follow-Ups:
- RE: Vlookup with multiple variables
  - From: Sam

References:
- Vlookup with multiple variables
  - From: Sam

Prev by Date: Re: Vlookup with multiple variables
Next by Date: Re: data lookup
Previous by thread: Re: Vlookup with multiple variables
Next by thread: RE: Vlookup with multiple variables
Index(es):
- Date
- Thread