"magmike" wrote: > =VLOOKUP(H2,'Lookup Table'!$A$2:$B$110,2,FALSE) > I know the problem is in my reference to H2. The cell is a ZIP Code. "magmike" <
[email protected]> wrote: > When I replaced the reference (H2) with an actual value (37185) it worked. Then the cell H2 probably contains (numeric) text instead of a number. That is, ISTEXT(H2) returns TRUE. (Confirm.) A quick fix might be: =VLOOKUP(--H2,'Lookup Table'!$A$2:$B$110,2,FALSE) Thedouble-negate (--) before H2 converts numeric text to a number. If that returns an error (probably #VALUE), there are other characters in H2 that prevent Excel from interpreting it as a number. Try: =VLOOKUP(--TRIM(SUBSTITUTE(H2,CHAR(160),"")),'Lookup Table'!$A$2:$B$110,2,FALSE) These are all short-term fixes. You should ask for help with a long-term fix. For that, we will need more information. For example, how did you enter the data into H2 (and others?) in the first place.