Formula error - data validation + HLOOKUP returns #N/A

[ratpackinc]

Simple pricing sheet for copier services.
Page sizes and pricing listed in grid at top. (Paper sizes formatted as text, pricing formatted as Currency.)
User enters data line in lower grid.
Data entry 'Paper Size' (column E) is Data Validation drop down - linked to grid at top.
Select 'Paper Size' and enter number value (column F). Cost calculates based on HLOOKUP in top grid using Data Validation value from 'Paper Size'.
=IF(F6="",0,(F6*HLOOKUP(E6,$C$2:$E$3,2)))

Works for all grid values (C2 - E2) except if value = "11x17". Select value "11x17" and results = #N/A.
Change value "11x17" to anything else not starting with "11", re-enter the data line, and calculation works. File attached.
Used Evaluate Formula - validation value is reading as text ("..") and grid values are formatted as text. Confirmed with =TYPE(). Tried E2 = '11x17 and = "11x17". No effect.

Change cell E2 value = "11x17" (E2) to ANYTHING else not starting with "11" and it works. But fails for E2 value = "11x17". Why?

[Special-K]

HLOOKUP requires the values to be in alphabetical order.
Re-sort the table into alphabetic order and it works.

[sktneer]

Try this.....

Please Login or Register  to view this content.

Use range_lookup as Exact Match which is False or 0 in the Hloopup formula.

[ratpackinc]

Thank you. Well I feel silly. Did not see the order was not properly sorted.
I usually avoid using V/HLOOKUP formulas for that very reason. (Prefer INDEX/MATCH.)