"Ronbo" wrote:
Frank:

Thanks alot for your help this time and the times
before. It is very much apprectiated. Your formula
works perfect. I need to use HLOOKUP because the lookup
criteria in A1 will not be the same next month, i.e. this
time it A1 is 1, next month it will be A1 will be 2, so
next month the formula in D1 has find the column the 1 is
in.


If you are saying that next month A1 will be 2 and B1 will be 1 (and that you then want to return values from column B) then you should change the Range in the Hlookup to A1:B3.