View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Antonov Antonov is offline
external usenet poster
 
Posts: 44
Default vlookup and calculations

hello everybody. I have a question: is it possible to have excel to look up
more cells (i.e. =vlookup(sheet1!$A$1and$C$1,sheet2!$A$1:$C$3) and if both
values are equal then multiply what's in cell sheet2! by another cell in
sheet1!?