Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |