Page 1 of 1

[Solved] LOOKUP Formula does not show results

PostPosted: Wed Nov 13, 2019 5:29 pm
by rcasey
I have a similar problem, and have tried all the solutions suggested here; but nothing has worked.

What is really strange is that my formula works, and displays, in the first cell in the column; but the remaining cells in the column are invisible! Yet, the forumla looks correct.

If there is a moderator still assisting in this forum, I would be grateful for any assistance. I have uploaded the .ods file. See sheet 'All data', cell E4

TIA,
--rick

 Edit: Spit fromFormula fields do not show results 

Re: LOOKUP Formula does not show results

PostPosted: Thu Nov 14, 2019 1:12 am
by MrProgrammer
Hi, and welcome to the forum. Thank you for the attachment demonstrating the difficulty.

rcasey wrote:I have a similar problem …
No, your problem is completely different, though the symptom is the same. In your case the =LOOKUP(B3;$D$3:$D$69;$E$2:$F$2) formula in E3 is bogus. Use =IF(ISERROR(VLOOKUP(B3;$D$3:$D$69;1;0));"YES";"NO") and fill the formula down the column.

[Tutorial] VLOOKUP questions and answers Q4/A4

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

Re: [SOLVED] LOOKUP Formula does not show results

PostPosted: Thu Nov 14, 2019 6:09 pm
by rcasey
Thanks! Worked like a charm...will check out the tutorials too.

--Rick