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!?
|