Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hlookup function dilemma
Do it like this:
=IF(ISNA(hlookup(A1,A2:A6,1,false)),"",hlookup(A1, A2:A6,1,false)) ISNA checks for #N/A and returns a blank if necessary. Hope this helps. Pete On Sep 29, 12:58*pm, RodJ wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hlookup function dilemma
Try this: =IF(ISERROR(HLOOKUP(A1,A2:A6,1,FALSE)),"",HLOOKUP( A1,A2:A6,1,FALSE)) Regards, Stefi €˛RodJ€¯ ezt Ć*rta: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hlookup function dilemma
Alternatively, to avoid using two HLOOKUP functions -
=IF(COUNTIF(A2:A6,A1)0,HLOOKUP(A1,A2:A6,1,FALSE), "") Muppet Man. On Sep 29, 1:10*pm, Pete_UK wrote: Do it like this: =IF(ISNA(hlookup(A1,A2:A6,1,false)),"",hlookup(A1, A2:A6,1,false)) ISNA checks for #N/A and returns a blank if necessary. Hope this helps. Pete On Sep 29, 12:58*pm, RodJ wrote: 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- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hlookup function dilemma
To all: Pete UK, MuppetMan, and Stefi. Why HLOOKUP? should be VLOOKUP instead.
=IF(ISNA(VLOOKUP(A1,A2:A6,1,0)),"",VLOOKUP(A1,A2:A 6,1,0)) I like this one better and more elegant =IF(COUNTIF(A2:A6,A1),A1,"") "RodJ" wrote: 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hlookup function dilemma
Hi Ashish, I tried this and failed. I might have chosen the wrong option...
-- RodJ "Ashish Mathur" wrote: Hi, You could also use conditional formatting to conceal error values -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "RodJ" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hlookup function | Excel Worksheet Functions | |||
HLOOKUP FUNCTION | Excel Worksheet Functions | |||
HLookup? or an array function?? | Excel Worksheet Functions | |||
HLookUp Function | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |