Issue 72781

Summary:

VLookup of empty cell fails to find match (rechercheV blank doesn't works)

Product:

Calc

Reporter:

chun <vcongy>

Component:

editing

Assignee:

spreadsheet <spreadsheet>

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

issues, kpalagin

Version:

OOo 2.0.3

Target Milestone:

---

Hardware:

OS:

Windows XP

ENHANCEMENT

---

---

Attachments:

Description	Flags
sample file	none

Description chun 2006-12-20 08:39:36 UTC

rechercheV with blank criters doesn't works.

Comment 1 kpalagin 2006-12-23 16:48:33 UTC

chun,
please elaborate and provide sample file if possible.

Comment 2 chun 2006-12-26 09:55:28 UTC

Created attachment 41708 [details]
sample file

Comment 3 chun 2006-12-26 10:01:50 UTC

At first, sorry for my english !

A RechercheV doesn't work if the search criter cell is blank. It result  N/A.

Comment 4 kpalagin 2006-12-26 12:07:47 UTC

So you are talking about VLOOKUP function. 
Confirming with OO m197 on WinXP - Vlookup would not search for contents of 
blank cell.

Comment 5 frank 2007-02-16 14:30:18 UTC

double to Issue 8088

*** This issue has been marked as a duplicate of 8088 ***

Comment 6 frank 2007-02-16 14:30:42 UTC

closed double