+ Reply to Thread
Results 1 to 5 of 5

convert text reference to real ref from address function ( not using indirect or eval udf)

  1. #1
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    convert text reference to real ref from address function ( not using indirect or eval udf)

    Hello friends,
    just wondering if there's a way around this one.

    The function address gets the cell address

    function concern is --> address (row(),column()) -> "A1"

    =indirect(address (row,column) gets the value of A1
    =evaluate(address (row,column))

    Question is,
    any other function that will convert this (Address function ) to real cell reference with out using the indirect the the old eval udf?


    thanks,
    regards
    vladimir
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: convert text reference to real ref from address function ( not using indirect or eval

    hi vlady, i don't think there is. if you're worried about the volatility of INDIRECT, maybe you can share your scenario?

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: convert text reference to real ref from address function ( not using indirect or eval

    here's the scenario..
    attached file..

    vladefsample.xlsx

    thanks for looking...

  4. #4
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: convert text reference to real ref from address function ( not using indirect or eval

    i remember the PM eg you gave was slightly different? haha. probably for this:
    =LEFT(LOOKUP(B10,B2:B4,C2:C4),FIND("*",LOOKUP(B10,B2:B4,C2:C4))-1)*LOOKUP(B10,B2:B4)

    is that it?

  5. #5
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: convert text reference to real ref from address function ( not using indirect or eval

    yup..
    thanks, the aspirin helped last weak but have it again today in my first post...

    regards,
    vladimir

  6. #6
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: convert text reference to real ref from address function ( not using indirect or eval

    was just looking at the sample you uploaded vlady, maybe something like this :vladefsample.s1.xlsm
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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