two condition for vlookup?

[Guest]

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

Shital

 

[Guest]

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"),D23)

Change the ranges and the comparisions (use cell references instead) as
appropiate

Hope this helps,
Miguel.

 

[Guest]

thnaks i will try and if any i will be back.
shital

 

[Guest]

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.

 

[Guest]

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