Forum Discussion
VLOOKUP values not updating
The 1st image reflects the result "x" which designates the cell the formula is looking in doesn't not have anything in it. The 2nd image is of the sheet that contains the cell where the formula is determining if there is a value in there or not. If it does it should return "Rec'd" (received) back in the "Opener" Sheet. The 3rd & 4th images are what happens when the cell in the sheet "v2.2" doesn't have a value in it and how the cell where the formula exists in sheet "Opener" reacts to the change in value.
As I had eluded to within my original post, I have two virtually identical formulas providing the same functionality in adjacent cells that work fine and these two that don't. I have tried all obvious substitution methods of changing operators within the formula but nothing enacts a change to a fully operating auto-update upon a change in value.
Douglas997t The are no images! And "virtually identical formulas" are NOT identical and may behave differently in different circumstances.
- Uploaded again...
And, in this case the formulas ARE essentially the same. The only differences is in the column reference and in the case where the data field being looked at being either a text field or numeric and the formulas reflect those nuances...Douglas997t Still no images.
- I watched them upload...will try again