"Regnab" wrote:
Yeah - it's set to Automatic. All the other formula's are updating etc
as per usual...

Welcome back! Other than checking the data consistency (between the lookup
values and the top row reference values in the hlookup's table array, eg:
check whether it's a case of real numbers being looked up/compared with text
numbers - or the other way around; check for any extra white spaces if its
text strings being compared - TRIM can be used to make the matching more
robust), I don't have further ideas on your subject line. Hang around awhile
for insights from others.

Btw, did the suggested incrementer for the hlookup's row_index_num work for
you in my response to your other post ( HLOOKUP - Adjusting the lookup
value...) ?
Perhaps you could throw a feedback line over there?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---