Quote:
Originally Posted by Kimberly
=HLOOKUP(E6,$A$2:$C$3,2,0)*D6
in cell G6 and copy down
By the way, you are multiplying in column G, but doesn't the label in cell G5 imply division?
|
Thanks Kimberly,
It works exactly what I want..
But I used it in Table, its give me #N/A error when i dont enter a value other cell.. (because of empy cell)
is there any solision for this error. on bottom of table I can not get the sum of amount because of this error. I want it to calculate empty cell as "0"
is it possiable...
thanks..