[Solved] LOOKUP Formula does not show results

Discuss the spreadsheet application

[Solved] LOOKUP Formula does not show results

Postby rcasey » Wed Nov 13, 2019 5:29 pm

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 
Attachments
ListServ-Volunteer-merge.ods
(39.36 KiB) Downloaded 6 times
Last edited by rcasey on Thu Nov 14, 2019 6:08 pm, edited 2 times in total.
OpenOffice 4.1.6 on MacOS 10.15.1
rcasey
 
Posts: 2
Joined: Wed Nov 13, 2019 5:20 pm

Re: LOOKUP Formula does not show results

Postby MrProgrammer » Thu Nov 14, 2019 1:12 am

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
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3891
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: [SOLVED] LOOKUP Formula does not show results

Postby rcasey » Thu Nov 14, 2019 6:09 pm

Thanks! Worked like a charm...will check out the tutorials too.

--Rick
OpenOffice 4.1.6 on MacOS 10.15.1
rcasey
 
Posts: 2
Joined: Wed Nov 13, 2019 5:20 pm


Return to Calc

Who is online

Users browsing this forum: baro and 21 guests