## [Solved] LOOKUP Formula does not show results

Discuss the spreadsheet application

### [Solved] LOOKUP Formula does not show results

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
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

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).

MrProgrammer
Moderator

Posts: 3955
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

### Re: [SOLVED] LOOKUP Formula does not show results

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

### Who is online

Users browsing this forum: RPG and 13 guests