Posted to microsoft.public.excel.worksheet.functions

Sue

external usenet poster

Posts: 285

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

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
Remove a Function	neska	Excel Discussion (Misc queries)	3	November 10th 07 10:56 AM
Remove function	Shayra	Excel Discussion (Misc queries)	3	December 8th 06 08:22 PM
How do your remove ROUND function?	michelle	Excel Worksheet Functions	3	July 28th 06 07:11 PM
function to add or remove	Michael Hayes	Excel Worksheet Functions	0	February 22nd 06 03:15 AM
How do I remove a function?	Uncle Bill	Excel Worksheet Functions	0	January 5th 06 01:20 AM

All times are GMT +1. The time now is 11:30 PM.

About Us

"It's about Microsoft Excel"