View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico Miguel Zapico is offline
external usenet poster
 
Posts: 95
Default 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