Forum Discussion
VLOOKUP values not updating
I am having trouble with Excel 365 when using VLOOKUP in the following manner; I have two iterations each not working properly. Iteration 1: =IF(VLOOKUP(v2.2!$C$6,v2.2!$L$8:$II$51,24,FALSE)="","Rec...
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.
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).