Hi, this is a screenshot of my 2 dimensional Match and Lookup - using 2 variables to derive at a cell. Everything works except for cases where the second variable is a 1.0, 2.0 or 3.0 - because I can't format these as numbers (it will truncate to 2 rather than keep 2.0) I format these fields as text, but MATCH seems to have a hard time matching 2.0 with 2.0 when they are both text.

00000034.png
Any suggestions? Thanks!

Screenshot: http://screencast.com/t/WtVfW6CY6