+ Reply to Thread
Results 1 to 36 of 36

INDIRECT function - need help

  1. #1
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    INDIRECT function - need help

    Still toiling away in Excel 2007.

    Trying to massage an INDIRECT function to do what I want it to, and having problems. Someone on this forum had given me this formula years ago, and it has worked perfectly. Now, I'm trying to adapt it to sort some other fields, and cannot figure for the life of me how to get it right.

    The formula I have been using is: =INDIRECT("Sales!M"&ROW()*3+4), but will need changing.

    The values I am using are being taken from an internet site, and for the new formula, I want to stay on the same worksheet.

    I am pasting them as text in column A, so changed the first part of the formula to =INDIRECT("A"&ROW()

    The second part of the formula has me stumped, and I've tried as many variations of numbers there as I can, but I simply do not understand the logic behind the choice of numbers in the first place, so that is what is keeping me from succeeding.

    The info I'm pasting has the needed values repeating every 14 rows.

    I've attached a sample worksheet, but I'll explain a little.
    A1 is a reminder to my foggy memory. A3 is where the data from the internet will be pasted as text. As you can see, the data repeats the 14th row after the first instance, with a space (blank row) in-between.
    Column C is where the values for A4, A18 and A32 and so on need to wind up.
    Column E is where the values for A6, A20 and A34 and so on will go.
    And you can see the pattern. I've filled C3, C4, C5, etc just to show which value needs to go where. What you see is a representation of where the value for that field should be coming from. I.e. value from A4 needs to show up in C3, value from A18 in C4, etc.

    If you can help with a formula, that'll be great. Even better though, would be if you also will explain the logic behind the 2nd part of the formula so I can understand it, and see how to do this myself in the future.

    I hope the sample spreadsheet is attached. The way this forum does it seems a little funky to me.

    Thanks for any help.

  2. #2
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    Now I think I've got the sample spreadsheet attached.
    Attached Files Attached Files

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: INDIRECT function - need help

    Quote Originally Posted by dansparts View Post
    Column C is where the values for A4, A18 and A32 and so on need to wind up.
    Column E is where the values for A6, A20 and A34 and so on will go.
    ...from A4 needs to show up in C3, value from A18 in C4, etc.
    No attachment?
    Anyway, with some basic info, I tried:
    In A6:
    Please Login or Register  to view this content.
    Copy up to A4:A5 and down to A7 to as far as you want

    If it does not help, try to attach a sample file.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    Untitled.png

    P/S:have seen attachment now. Working on this.
    Quang PT

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: INDIRECT function - need help

    Hi,

    Does the attached help

    It uses formulae like this in C3 with row 2 containing a column offset number

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: INDIRECT function - need help

    OK now I got it.

    Start with C3:
    =OFFSET($A$4,MOD(ROW(1:1)-1,14),)
    Copy to E3 and edit A4 to A6
    =OFFSET($A$6,MOD(ROW(1:1)-1,14),)
    Similar copy and edit accross to O3
    Copy C3:O3 down

  6. #6
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    @bebo

    Using that formula, copied all the way down Column C, give me the value from A4 into C3, but then the value from A5 into C4, value from A6 into C5, etc.

    I need value from A18 in C4, not value from A5.

    @Richard -

    I really don't want to have to "clutter" things up with something like the column offset number.

    Can the INDIRECT function not be used?

  7. #7
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: INDIRECT function - need help

    Quote Originally Posted by dansparts View Post
    @bebo

    Using that formula, copied all the way down Column C, give me the value from A4 into C3, but then the value from A5 into C4, value from A6 into C5, etc.

    I need value from A18 in C4, not value from A5.
    Opp, sorry for my mistake. I forgot to time it to 14:

    =OFFSET($A$4,MOD(ROW(1:1)-1,14)*14,)

    Or simple like this:
    =OFFSET($A$4,(ROW(1:1)-1)*14,)

  8. #8
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    @bebo

    That worked.

    I need to understand how/why this works, since I will need to be adapting this formula to several other worksheets, with different amounts of rows & columns of the pasted text.

    What is the difference of the MOD in the formula or not?

    I see that the (1:1) changes as it is pasted down the column to (2:2), (3:3), etc. And the -1) part?

    I assume the *14 will need to be changed to whatever spacing of rows apart the data repeats on.

    Why use this OFFSET function, instead of INDIRECT?

    Also, is not OFFSET for a static range? The text data I will be pasting in will vary in length almost always. In other words, sometimes I paste information from 3 records, sometimes from 25 records, sometime from 150 records. Will that affect things?

    Sorry for questions that might seem elementary, but while I use Excel all the time, I'm not at all well-versed in complicated formulas like this. Most of my "expertise" (cough, cough) is simple things like =SUM.
    Last edited by dansparts; 12-07-2017 at 10:46 PM.

  9. #9
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: INDIRECT function - need help

    ROW(1:1) copy down to be 1;2;3;4;...
    ROW(1:1)-1 copy down to be 0;1;2;3;...
    OFFSET($A$4,0) is $A$4 it self
    OFFSET($A$4,1) is start from $A$4, going down 1 row, refer to $A$5

    (ROW(1:1)-1)*14 copy down to be 0;14;28;42,...
    OFFSET($A$4,ROW(1:1)-1)*14) = OFFSET($A$4,0) refer to $A$4 it self
    OFFSET($A$4,ROW(2:2)-1)*14) = OFFSET($A$4,14) refer to $A$18
    ...

    Hope it helps

  10. #10
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    Still trying to understand.

    If I was pasting my text into A2, instead of A3, and I then wanted the value from A3 (not as currently A4) to go to C3, what would change in the formula? Just the $A$4 to $A$3?

    Have one other problem to solve.

    One of my text strings actually looks like this: 2016-04-24 03928900 PTN0327. Is there any easy way to split these 3 pieces of data apart (they are separated by a space) and put them into 3 different columns? String #1, the date, is always the same number of characters (10). Around 90% of the records I'm using will have the same number of characters (8) in the 2nd string, the part number. The third string will have anywhere from 2 to 10 characters. Previously, I have messed around with =LEFT or =RIGHT and multiple splittings in several columns, then referencing the final result back to the column I want it in. Very cumbersome and messy.

    Is there any easy way to do that, and account for variability in number of characters in strings 2 & 3?

  11. #11
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: INDIRECT function - need help

    Quote Originally Posted by dansparts View Post
    Still trying to understand.
    If I was pasting my text into A2, instead of A3, and I then wanted the value from A3 (not as currently A4) to go to C3, what would change in the formula? Just the $A$4 to $A$3?
    Not very clear for me, you just to give a trial to see what happened and post it again.

    Quote Originally Posted by dansparts View Post
    Is there any easy way to do that, and account for variability in number of characters in strings 2 & 3?
    Assuming string is in A1
    In B1:
    Please Login or Register  to view this content.
    In C1:
    Please Login or Register  to view this content.
    In D1:
    Please Login or Register  to view this content.
    Sharing: Replace any space in string with 100 spaces, then use LEFT(...,100), MID( take 100 chars start from 100) and RIGHT(...,100)
    Last edited by AliGW; 12-10-2017 at 04:19 AM. Reason: Quotation cut down to relevant portion.

  12. #12
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: INDIRECT function - need help

    Quote Originally Posted by bebo021999 View Post
    In B1:
    Please Login or Register  to view this content.
    Note: formula +0 to get real date instead of text

  13. #13
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    That's what I needed!

    I don't want an actual date, but rather the date listed in the text, so what you gave me works fine. The dates in the records are all past dates, nothing current.

    One last item. Can I get rid of leading zeroes in the MID trim? I looked at formatting the column, but didn't see anything. Would I have to do a custom format?

  14. #14
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: INDIRECT function - need help

    Quote Originally Posted by dansparts View Post
    Can I get rid of leading zeroes in the MID trim? I looked at formatting the column, but didn't see anything. Would I have to do a custom format?
    One way to change to real number:
    =formula+0

  15. #15
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    Neither of those formulas seems to work correctly.

    The 2nd one got rid of the leading zero in sub-string #2, but re-attached sub-string #3.

  16. #16
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: INDIRECT function - need help

    Quote Originally Posted by dansparts View Post
    Neither of those formulas seems to work correctly.
    The 2nd one got rid of the leading zero in sub-string #2, but re-attached sub-string #3.
    Have you tried to add zero to that MID formula?

    =TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",100)),100,100))+0

  17. #17
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    That worked well on the #2 sub-strings that are all numeric. I have some #2 sub-strings that are alpha-numeric, and it appears to return #VALUE! on those.

    I don't have too many of those, and could correct those manually, if there is no easy solution.

    Thank you for all your help. It is late here, and I will do some experimenting tomorrow and reply if I have more questions.

  18. #18
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: INDIRECT function - need help

    Quote Originally Posted by dansparts View Post
    @bebo

    @Richard -

    I really don't want to have to "clutter" things up with something like the column offset number.

    Can the INDIRECT function not be used?
    I simply added the column number to make the formula shorter. If you don't want to include that then just remove the reference to it in the formula and replace it with the number in the formula. So for instance where in E3 i gave you
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    use instead
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Adjust the other cells in a similar way.
    This is no different a concept to making the similar adjustment you'd have to do with an INDIRECT() function

    Don't get hung up on an INDIRECT.
    Personally I generally prefer to use the OFFSET() function, which for many things does the same as an INDIRECT, since it's simpler to understand and usually much shorter.

  19. #19
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    Bebo & Richard -

    Thank you both so much for the help so far. Things are progressing very nicely, but there are just a few more details at this point that would complete this spreadsheet to where I need it right now.

    1. As mentioned above, using this:
    =TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",100)),100,100))+0
    pulls out the sub-string #2 and disposes of the leading zero on numeric values nicely, but is there any way I can accommodate alpha-numeric values in sub-string 2? While still correctly getting the numerics? I.e. a formula that would do both. The alpha-numerics would look similar to this: M26J-583-BLDE. The number of characters and ratio of letters to numbers in each of the 3 positions separated by dashes can vary, but there will always be 3 sections to the string, separated by the 2 dashes, and always one space before it and one space after it. In the alpha-numeric case the full string would look like this: 2016-04-24 M26J-583-BLDE PTN0327. For what it's worth, this particular string is the date of entry, part number and source marker I am using to make a SKU.

    2. Again, in separating sub-strings. I have a string that looks like this:
    408936994776 Name of item 6033
    Sub-string #1 is always 12 characters, always strictly numeric. That sub-string is no problem, and the formulas you've already given me work fine for that. I am having trouble with sub-string #2 here. Sub-string #2 is everything other than the 12-character numeric at left, and all of it needs to be pulled out complete - words and number, as one intact piece. Number of words and spaces varies widely, and there is a number (all-numeric or alpha-numeric) at the end of the name about 90%-95% of the time, but not 100%.

    3. Still separating sub-strings. Another string looks like this:
    nameid (117) Name of person
    I need to pull out sub-string #1 - nameid - this is already done with existing formulas.
    Then only need sub-string #3 - Name of person. This can be 2-3-4 (etc) words, separated by spaces - all variable. I need to pull out all the words in this sub-string as one unit. It is the customer's name. The number with parentheses, in the middle of the full string, always exists in this string, but the number contained in the parentheses may have a variable number of character. While I don't need to pull out this number in this case, I thought maybe sub-string #3 can be pulled out by referencing the ")" and/or the space to the right of it somehow?

    I've tried to give you as many of the variables I can think of that need to be accounted for in the 3 items above, and I hope I haven't overlooked anything.

    Again, I want to thank you for your efforts to help me. I am slowly learning more about these formulas, but obviously have a long way to go. It's great when you find people who take their time to help others nowadays.

  20. #20
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: INDIRECT function - need help

    Hi,

    Could you upload the workbook with all permutations of strings & data and manually add the results you want to see.
    I find it much easier to provide solutions when I can see the end goal.

  21. #21
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    Richard -

    Finally had time to do up a sample worksheet, attached.

    Sub-strings I need formulas for are in red text.

    The formula in F3, if pasted into F4, returns #VALUE, because of the alpha-numeric in A43, not an all-numeric.

    Problem I'm having is needing to pull records from two different places in the website, neither of which are set up/aligned the same as the other. That throws the pasted text into a tizzy sometimes, and bunches different sub-strings together. Add in Chrome and Firefox rendering things slightly differently (more/less blank rows from one to the other). Both Firefox and Chrome throw the information into two columns, with Chrome putting everything on a separate row, no matter the column, while Firefox has a couple instances of values in BOTH columns, same row.

    That's one reason I feel like I'm chasing my tail.

    Thanks for any help.
    Attached Files Attached Files

  22. #22
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: INDIRECT function - need help

    Try this in C4:

    =TRIM(SUBSTITUTE(R3,D3,""))

    In H3:

    =MID(P3,FIND(")",P3)+2,9999999)

    In F3:

    =TRIM(RIGHT(SUBSTITUTE(R3," ",REPT(" ",999)),900))
    Last edited by AliGW; 12-10-2017 at 04:29 AM.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  23. #23
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    @Ali -

    Thanks so much for chiming in to help.

    The first two formulas worked perfectly!!

    The third one, however, has a problem.

    When pasted into F3, it returns the value from the end of sub-string #2 in R3. I see that you've taken the value from the end of that sub-string in R, rather than from the sub-string #2 in the middle of the string in Q.

    When that formula is pasted into F4, it returns the value from the end of sub-string #2 in R3 again, instead of the value from R4.

    Unfortunately, using the end of sub-string #2 in R may not be correct in all instances. There are enough of those instances where a different number was used in sub-string #2 in Q than was used at the end of the sub-string #2 in R. And in some cases, there may not be a number at all at the end of sub-string #2 in R, while there is a value in Q.

    So, I really need to use the sub-string #2 in Q as the source. Is there any hope for that with interchangeability between all-numeric and alpha-numeric?

    Thanks for your help.

  24. #24
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: INDIRECT function - need help

    When that formula is pasted into F4, it returns the value from the end of sub-string #2 in R3 again, instead of the value from R4.
    Don't copy and paste - drag copy down instead. See the attached.
    Attached Files Attached Files

  25. #25
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: INDIRECT function - need help

    Try this in F3 copied down:

    =TRIM(LEFT(SUBSTITUTE(TRIM(MID(Q3,FIND(" ",Q3),90))," ",REPT(" ",999)),99))

  26. #26
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: INDIRECT function - need help

    In F3


    =SUBSTITUTE(SUBSTITUTE(Q3,E3,""),G3,"")

    ???

  27. #27
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    Ah, yes, I see. I didn't do that right. When I drag, it does work perfectly.

    However, I still need to get the value from Q, not from R.

    Thanks again.

  28. #28
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: INDIRECT function - need help

    See post #25.

  29. #29
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    John -

    That worked well for taking care of all-numeric and alpha-numeric, but did not get rid of the leading zero on the all-numeric.

    Thanks.

  30. #30
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: INDIRECT function - need help

    Look at post #25.

  31. #31
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    Ali -

    Yes, that works as well, but still the leading zero is there on all-numeric.

    When I add the +0 (as suggested by Bebo, above), then it returns #VALUE on alpha-numeric.

    I could make another column(s) and use formulas there to differentiate between all- and alpha- and manipulate there?

  32. #32
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: INDIRECT function - need help

    Try this:

    =IF(LEFT(TRIM(LEFT(SUBSTITUTE(TRIM(MID(Q3,FIND(" ",Q3),90))," ",REPT(" ",999)),99)),1)="0",MID(SUBSTITUTE(TRIM(MID(Q3,FIND(" ",Q3),90))," ",REPT(" ",999)),2,99),TRIM(LEFT(SUBSTITUTE(TRIM(MID(Q3,FIND(" ",Q3),90))," ",REPT(" ",999)),99)))

    Drag copy down.

  33. #33
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: INDIRECT function - need help

    Try


    =TEXT(SUBSTITUTE(SUBSTITUTE(Q3,E3,""),G3,""),"#000000")

  34. #34
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    Ali -

    YES! That worked!

    If it's alright with the Moderators, I'm going to leave this thread open and not marked as Solved yet, as there are a couple more tweaks I want to do, but will not have time to get to posting anything about them until Tuesday. If that's not ok, we can make this solved and I can start a new thread.

    Thanks so much for all the time and effort all of you have put into this. It is going to save me literally hundreds of hours of time over the next months/years. Ever since a website shut down that was feeding me all this information in an already paste-able format, I've been having to copy and paste all the information, string by string, sub-string by sub-string. HUGE waste of time, and an inconceivable lack of foresight on the website that shut down. And probably a large economic opportunity for anyone with enough expertise, wanting to step into that void to fill that vacuum.

  35. #35
    Registered User
    Join Date
    12-07-2017
    Location
    Ohio
    MS-Off Ver
    2007
    Posts
    22

    Re: INDIRECT function - need help

    @John -

    Yes, that worked,too! Just proved the old theory of more than one way to skin a cat!

    Thanks.

  36. #36
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: INDIRECT function - need help

    Hi,

    Here's my offering
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Is INDIRECT function volatile within an IF function?
    By Monimonika in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2017, 12:53 PM
  2. [SOLVED] INDIRECT Function with multiple sheets - SUMIF, INDIRECT & MATCH
    By DJDRU in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-07-2014, 08:42 AM
  3. Using Indirect function inside the Search function
    By skhari in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2014, 05:32 PM
  4. [SOLVED] Combining Text Function with Indirect Function
    By ninmjj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2013, 10:34 AM
  5. Sumif function using indirect function and data from different sheet
    By pronky007 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2013, 12:40 PM
  6. [SOLVED] Using ROW function inside of both an Indirect and Index function returns #VALUE
    By xandermacleod in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-11-2012, 06:22 PM
  7. MATCH function within INDIRECT function not working
    By mgerada in forum Excel General
    Replies: 2
    Last Post: 09-04-2011, 08:37 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1