Forum Discussion
VLOOKUP values not updating
Douglas997t You write "If the value exists it in the referenced cell it should return "Rec'd". If the same cell is empty it should return "x" to the cell containing the VLOOKUP formula in sheet "Opener"...it does not."
But the formula suggests the opposite. If VLOOKUP finds a blank (or 0), it returns "Record" otherwise "x".
If this makes no sense, perhaps you can share file (via Onedrive) demonstrating the issue.
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.
- Is there a way to post a screen shot of the effected areas. It would make more sense that way.
Douglas997t Press the camera icon in the editor when you write a response and follow the instructions to upload a picture (i.e. a screenshot).
