Hello. I am having trouble with a vlookup. I know that the formula
is working correctly--'s just that the data in column that I reference
first is composed of formulas. When I flatten those formulas, the
vlookup works fine, but if they are left as formulas, my vlookup just
returns "N/A." What is the trick to fixing this? Thanks!