Menu
Ask a question Report

How to add iferror to formula [Solved/Closed]

- - Latest reply:  Talahjer - Jan 26, 2011 at 05:29 AM
Office Software Ask a question Report
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.


See more 

3 replies

Best answer
Report Respond to rayh
1
Thank you
if(isna(formula),"Error",formula)

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM 4594 users have said thank you to us this month

Report
-
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
Report
-
Dear Rayh

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

Thank you
Report Respond to Talahjer
0
Thank you
dear Rayh

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

Thank you
Report Respond to Talahjer
0
Thank you
Dear Rayh

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

Thank you
Ask a question