Solved How to use INDIRECT

December 19, 2019 at 02:10:20
Specs: Windows 10
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,"")))


See More: How to use INDIRECT

Reply ↓  Report •

#1
December 19, 2019 at 04:44:03
rows references continuously added and deleted to avoid formula error

Your 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

http://www.skeptic.com/


Reply ↓  Report •

#2
December 19, 2019 at 06:43:28
✔ Best Answer
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


Reply ↓  Report •
Related Solutions


Ask Question