ExcelBanter - #Empty error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #Empty error (https://www.excelbanter.com/excel-discussion-misc-queries/112990-empty-error.html)

Alan P

#Empty error

I've never seen this before. A VLOOKUP query returned #EMPTY. Does anyone
know what this means? Didn't see anything in Excel Help even mentioning
this error.

Thanks,

Al

Alan P

#Empty error

Please disregard - turns out that was the actual data in the cell, must have
been a download error in the lookup table.

"Alan P" wrote:

I've never seen this before. A VLOOKUP query returned #EMPTY. Does anyone
know what this means? Didn't see anything in Excel Help even mentioning
this error.

Thanks,

Al

Dave Peterson

#Empty error

Any chance that the value returned is actually #EMPTY?

Alan P wrote:

I've never seen this before. A VLOOKUP query returned #EMPTY. Does anyone
know what this means? Didn't see anything in Excel Help even mentioning
this error.

Thanks,

Al

--

Dave Peterson

All times are GMT +1. The time now is 06:55 PM.