| 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?
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 | |||
Hybrid Mode
