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
|