Below is my formula having rows references continuously added and deleted to

avoid formula error how I can use INDIRECT with below formula=IF(ISNUMBER(SEARCH("hexacomp",C15,1)),MID(C15,10,4)/1000*E15,

IF(ISNUMBER(SEARCH("hexacon",C15,1)),MID(C15,11,4)/1000*E15,

IF(ISNUMBER(SEARCH("pacvoid",C15,1)),MID(C15,11,4)/1000*E15,"")))

rows references continuously added and deleted to avoid formula errorYour formula has only two cell references, so how is the INDIRECT() function going to be of assistance?

I can't see your spreadsheet from where I'm sitting, and I have no idea what it is your trying to accomplish.

You'll need to explain a bit more.

MIKE

As Mike says, it's not clear what you want to use the INDIRECT function for, but I'll give it a shot. If you are changing C15 and E15 all the time, then you might be able to use something like this, where A1 and A2 would contain C15 and E15 respectively:

(untested, it should be close)

=IF(ISNUMBER(SEARCH("hexacomp",INDIRECT(A1),1)),MID(INDIRECT(A1),10,4)/1000*INDIRECT(A2),

etc.If all you need to change is the Row reference, then something like this might work, where A1 contains the ever changing Row reference:

=IF(ISNUMBER(SEARCH("hexacomp",INDIRECT("C" & A1),1) etc.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Ask Your Question

Weekly Poll