| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
remove #n/a from the columnI've used a function
I have used a function and dont want to get #n/a but replace with a blank
after using =INDEX('K1'!A:B, MATCH(HAM!C62, 'K1'!A:A,0),2) -- Sue |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
remove #n/a from the columnI've used a function
You can do it like this:
=IF(ISNA(MATCH(HAM!C62,'K1'!A:A,0)),"",INDEX('K1'! A:B,MATCH(HAM! C62,'K1'!A:A,0),2)) Hope this helps. Pete On Jul 25, 6:13*pm, Sue wrote: I have used a function and dont want to get #n/a but replace with a blank after using * =INDEX('K1'!A:B, MATCH(HAM!C62, 'K1'!A:A,0),2) -- Sue |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove a Function | Excel Discussion (Misc queries) | |||
| Remove function | Excel Discussion (Misc queries) | |||
| How do your remove ROUND function? | Excel Worksheet Functions | |||
| function to add or remove | Excel Worksheet Functions | |||
| How do I remove a function? | Excel Worksheet Functions | |||
Hybrid Mode
