Attached is a workbook with 2 worksheets. On the first worksheet I have a simple vlookup formula that will only populate correctly when I select the value in column A (1st worksheet) and hit f2 and enter. Within the workbook is a macro that uses sendkeys to hit f2 and enter, but that does not even work correctly. Is there a way to fix this issue? I do not want to hit f2 and enter manually. For that matter, I don't even like to use sendkeys in my VBA, but I will as a last resort.