Hello,
very frustrating problem that I'm sure is super easy/obvious to someone else, but I've got a nested vlookup with an IF formula on a sheet - It's looking at 100 lines, 89 of those lines the formula works, the other eleven it's showing #value.
what's odd is, if I remove the IF part of the formula, the lookup brings the correct answer, so I know the information I'm looking for is there, but what I can't work out is why IF the formula is true (proven by just using the lookup), it won't write the response I want for these lines? If I separate the formula, so the lookup is in one box and the IF is in another I get the response I want, but when combined #value
Formula looks like this =IF(VLOOKUP(B50,'Name of sheet'!F:F,1,0),"CORRECT ANSWER","")
Can someone show me how stupid I'm being please?
Thanks.
Bookmarks