I am having issues with the .Find function within VBA. I have two worksheets: Data and Outputs. The .Find function first matches the values in column F of the Outputs sheet with the values in column F of the Data sheet. It then returns all values from the matched row in the Data sheet to the row with the searched value in the Outputs sheet.
I am experiencing my problem when I reach whole numbers. For example, in row 40 out the Output sheet, the function is supposed to lookup the value "3.00." When stepping through my code, however, it seems to interpret this number as "1.30." I have played around with this for a while and cannot seem to figure out what is going wrong. Attached is my workbook. Any help is greatly appreciated. Thanks!