| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
two condition for vlookup?
I have data where i have to put two condition than it should take next column
data. I have field like... ThickNess,Class, Area,Weight 4,L,12,321 4.85,M,23.4,136 and so on. I want to lookup data when i entry both ThickNess & Class than it should give Area,Weight I try vlookup but not working. Any Help Thanks ****al |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
two condition for vlookup?
You can use sumproduct instead, something like:
Area: =SUMPRODUCT(--(A2:A3=4.85),--(B2:B3="M"),C2:C3) Weight: =SUMPRODUCT(--(A2:A3=4.85),--(B2:B3="M"),D2:D3) Change the ranges and the comparisions (use cell references instead) as appropiate Hope this helps, Miguel. "****al shah" wrote: I have data where i have to put two condition than it should take next column data. I have field like... ThickNess,Class, Area,Weight 4,L,12,321 4.85,M,23.4,136 and so on. I want to lookup data when i entry both ThickNess & Class than it should give Area,Weight I try vlookup but not working. Any Help Thanks ****al |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
two condition for vlookup?
thnaks i will try and if any i will be back.
****al "Miguel Zapico" wrote: If the combination of Thickness and class is unique, the sumproduct formula will return the value you look for, as there will be only one value that won't be multiplied by zero in all the range. Try it with a few values. If that is not unique, the formula will give you misleading information, but only in that case. Miguel. "****al shah" wrote: thanks for reply so fast Miguel. I just want to lookup Area & Weight value for refance into other sheet when i entry ThickNess & Class. I don't want to make any sum or product. Is this possible. thanks "Miguel Zapico" wrote: You can use sumproduct instead, something like: Area: =SUMPRODUCT(--(A2:A3=4.85),--(B2:B3="M"),C2:C3) Weight: =SUMPRODUCT(--(A2:A3=4.85),--(B2:B3="M"),D2:D3) Change the ranges and the comparisions (use cell references instead) as appropiate Hope this helps, Miguel. "****al shah" wrote: I have data where i have to put two condition than it should take next column data. I have field like... ThickNess,Class, Area,Weight 4,L,12,321 4.85,M,23.4,136 and so on. I want to lookup data when i entry both ThickNess & Class than it should give Area,Weight I try vlookup but not working. Any Help Thanks ****al |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
two condition for vlookup?
If the combination of Thickness and class is unique, the sumproduct formula
will return the value you look for, as there will be only one value that won't be multiplied by zero in all the range. Try it with a few values. If that is not unique, the formula will give you misleading information, but only in that case. Miguel. "****al shah" wrote: thanks for reply so fast Miguel. I just want to lookup Area & Weight value for refance into other sheet when i entry ThickNess & Class. I don't want to make any sum or product. Is this possible. thanks "Miguel Zapico" wrote: You can use sumproduct instead, something like: Area: =SUMPRODUCT(--(A2:A3=4.85),--(B2:B3="M"),C2:C3) Weight: =SUMPRODUCT(--(A2:A3=4.85),--(B2:B3="M"),D2:D3) Change the ranges and the comparisions (use cell references instead) as appropiate Hope this helps, Miguel. "****al shah" wrote: I have data where i have to put two condition than it should take next column data. I have field like... ThickNess,Class, Area,Weight 4,L,12,321 4.85,M,23.4,136 and so on. I want to lookup data when i entry both ThickNess & Class than it should give Area,Weight I try vlookup but not working. Any Help Thanks ****al |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
two condition for vlookup?
thanks for reply so fast Miguel.
I just want to lookup Area & Weight value for refance into other sheet when i entry ThickNess & Class. I don't want to make any sum or product. Is this possible. thanks "Miguel Zapico" wrote: You can use sumproduct instead, something like: Area: =SUMPRODUCT(--(A2:A3=4.85),--(B2:B3="M"),C2:C3) Weight: =SUMPRODUCT(--(A2:A3=4.85),--(B2:B3="M"),D2:D3) Change the ranges and the comparisions (use cell references instead) as appropiate Hope this helps, Miguel. "****al shah" wrote: I have data where i have to put two condition than it should take next column data. I have field like... ThickNess,Class, Area,Weight 4,L,12,321 4.85,M,23.4,136 and so on. I want to lookup data when i entry both ThickNess & Class than it should give Area,Weight I try vlookup but not working. Any Help Thanks ****al |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 logical condition if statement | Excel Worksheet Functions | |||
| If more than condition forumula | Excel Worksheet Functions | |||
| conditional formatting - multiple condition | Excel Discussion (Misc queries) | |||
| Condition IF | Excel Discussion (Misc queries) | |||
| Add condition to formula | Excel Worksheet Functions | |||
Linear Mode
