Typing the first vlookup yields the correct result. When I pull down the cell reference to use the same vlookup on other cells, the vlookup recognizes that the formula has changed, but still delivers the result in the first cell.
Example
LookupValue Formula Result
A4A VLOOKUP(E5,Sheet1!$A$5:$N$224,6,FALSE) .0716243
AAAE VLOOKUP(E6,Sheet1!$A$5:$N$224,6,FALSE) .0716243
When I manually re-enter 'E6,' in the second row, the result value changes, but the same thing occurs when I pull that cell reference down (to copy).
I have all ways I know to convert the lookup values to numbers, but when I check them with =isnumber(), I am still receiving 'FALSE'. Is this the problem?
Thank you!