Actually, a little caffeine and transposing the table solved my problems.
Got it working fine now. Thanks for the help though!

"Max" wrote:

"Dan Belcher" wrote:
.. I must repeat this question except
using HLOOKUP instead of VLOOKUP. Try:

=HLOOKUP(D24,$A$6:$E$13,
MATCH(C24,$A$6:$A$13,TRUE),0)*E24*$E$16
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--