Posted to microsoft.public.excel.worksheet.functions

RodJ

external usenet poster

Posts: 11

hlookup function dilemma

the result of my hlookup is #N/A as my formula reads:
hlookup(A1,A2:A6,1,false).

Question: How do I make this #N/A invisible? I would rather see a blank cell
as it clutters my spreadsheet.

Thanks
--
RodJ

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
hlookup function	ahiru	Excel Worksheet Functions	5	March 30th 06 08:23 PM
HLOOKUP FUNCTION	Effie	Excel Worksheet Functions	0	May 24th 05 04:04 PM
HLookup? or an array function??	Murph	Excel Worksheet Functions	5	May 11th 05 05:44 PM
HLookUp Function	Louise	Excel Worksheet Functions	4	February 25th 05 04:41 PM
Counting Function Dilemma	Simon Lloyd	Excel Worksheet Functions	0	November 8th 04 03:13 PM

All times are GMT +1. The time now is 03:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us