View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shital shah shital shah is offline
external usenet poster
 
Posts: 61
Default 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