Previous Topic Next Topic

How to add iferror to formula

Solved/Closed
Talahjer - Jan 26, 2011 at 02:47 AM
 Talahjer - Jan 26, 2011 at 05:29 AM
Dear all

i have an excel database which search for a word in a cell and if it finds it, it puts it in another cell. The problem is the sell contains #N/A until it finds a word to be replaced. I was wondering if there is a possibility to add iferror to the formula in order to show the cell empty inested of showing #N/A?

i am really looking for your support and help as this is the best site to place a question

Thank you in advance.


Related:

3 replies

Answer 1 / 3
rayh
Jan 26, 2011 at 05:12 AM
if(isna(formula),"Error",formula)
1
Talahjer
Jan 26, 2011 at 05:22 AM
dear Rayh

i am sorry for bothering you but I tried to addmy formula whic is
=LOOKUP(2^15,SEARCH(GoverAndDist!A$1:T$1,H4855),GoverAndDist!A$1:T$1)
to the one you gave me but honesly I could not.
if you do not mind, plese combine both formulas

thanks in advance
0
Talahjer
Jan 26, 2011 at 05:29 AM
Dear Rayh

I applied your formula and it was resolved. You are the best

Thank you
0
Answer 2 / 3
Talahjer
Jan 26, 2011 at 05:27 AM
dear Rayh

iapplied your formula and it was resolved. You are the best

Thank you
0
Answer 3 / 3
Talahjer
Jan 26, 2011 at 05:29 AM
Dear Rayh

I applied your formula and it was resolved. You are the best

Thank you
0