Question : Hlookup has to take value from first row
since date is there on top
it works only if the date is at the end. Why ?
=HLOOKUP(F2,B2:D$6,E2,0)
see the E2 it takes from below the value not from top i.e. b1 to d1
instead it takes from b6 : d6.

In the example above, the lookup row's value in E2
is still counted from the Top row, i.e. *B2:D2*
for the formula above: =HLOOKUP(F2,B2:D$6,E2,0)
so think there's nothing unusual happening here <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----