|2 things come to mind:|
1 - Why are you using a range_lookup argument of TRUE?
Aren't you looking for exact matches? TRUE (or 1) is when you are looking for an approximate match. Review the Help file for VLOOKUP for an explanation.
Try changing range_lookup argument to FALSE (or 0) and see what happens.
2 - If changing the range_lookup argument to FALSE (or 0) returns a #N/A, then you don't have an exact match between the value in E110 and any value in your table_array.
An incorrect return value when using a range_lookup argument of TRUE (or 1) coupled with a #N/A return value when using a range_lookup argument of FALSE (or 0) would lead me towards thinking that there is a subtle difference between your lookup_value and the data in your table_array.
I would look for leading or trailing spaces or other hidden characters.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.