HLookup formula

Hi there
Following is an example of an HLOOKUP formula I'm using:

=HLOOKUP(A1,$B$2:$E$5,4,FALSE)

The problem I'm having is that if a user inserts a row within the range B2:E5, then it throws my lookup formula out, because the formula should now be looking at row 5 and not row 4. How do I get the number 4 in the formula to be a variable that always selects the last row of the specified (variable) range?

Thanks!
Sunil

Try,

=HLOOKUP(A1,$B$2:$E$5,ROWS($B$2:$E$5),FALSE)