I realize you found an alternate method. If you were wondering why the LOOKUP formula was not working, it is because your lookup array was not in ascending order. In order for it to work, values must be sorted low to high.