Vlookup
 

Hi

I am using vlookup function to search data but vlookup doesn't work when
there are more than one record of same value. Is it possible to search from
any excel function to lookup for 2 conditions. For example :

Vendor # Code Amounts
123 1 122
123 2 123
123 5 160

If I use vlookup to find data for vendor no.123, each row is showing first
match i.e. amount 122.. I need a formula to look for both conditions vendor
number & code numbers. Please help.
Thanks
Jai

Hi Jai,
See what Chip Pearson has to say
http://www.cpearson.com/excel/lookups.htm#DoubleLookup

ray

"Jai" wrote:

Hi

I am using vlookup function to search data but vlookup doesn't work when
there are more than one record of same value. Is it possible to search from
any excel function to lookup for 2 conditions. For example :

Vendor # Code Amounts
123 1 122
123 2 123
123 5 160

If I use vlookup to find data for vendor no.123, each row is showing first
match i.e. amount 122.. I need a formula to look for both conditions vendor
number & code numbers. Please help.
Thanks
Jai

Thanks. It's very helpful

"Ray A" wrote:

Hi Jai,
See what Chip Pearson has to say
http://www.cpearson.com/excel/lookups.htm#DoubleLookup

ray

"Jai" wrote:

Hi

I am using vlookup function to search data but vlookup doesn't work when
there are more than one record of same value. Is it possible to search from
any excel function to lookup for 2 conditions. For example :

Vendor # Code Amounts
123 1 122
123 2 123
123 5 160

If I use vlookup to find data for vendor no.123, each row is showing first
match i.e. amount 122.. I need a formula to look for both conditions vendor
number & code numbers. Please help.
Thanks
Jai