+ Reply to Thread
Results 1 to 9 of 9

Find cell value but cell name or vlookup with cell name

  1. 07-07-2021, 10:15 AM #1
    ELFIJKA
    ELFIJKA is offline
    Registered User
    Join Date
    10-04-2017
    Location
    Dublin
    MS-Off Ver
    Microsoft 365 Apps for Enterprise
    Posts
    34

    Find cell value but cell name or vlookup with cell name

    Hello! Again I need help of guru and I hope there is a simple solution that I never thought about...

    I have a Matrix of prices, see sample file attached. Each Price has cell name of underscore and article number (eg. _4000123456)

    I need to extract the prices into listed format like in column F, but what formula can I use to link them to matrix (B:C) and get result in G?
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-07-2021, 10:21 AM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Find cell value but cell name or vlookup with cell name

    What's the linkage between _4000123456 and the stuff that's in cols A-C??
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 07-07-2021, 10:23 AM #3
    ELFIJKA
    ELFIJKA is offline
    Registered User
    Join Date
    10-04-2017
    Location
    Dublin
    MS-Off Ver
    Microsoft 365 Apps for Enterprise
    Posts
    34

    Re: Find cell value but cell name or vlookup with cell name

    Name of Cell B5 is _400012345
    Reply With QuoteRegister To Reply
  4. 07-07-2021, 10:26 AM #4
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Find cell value but cell name or vlookup with cell name

    Duhh! so it is...
    Reply With QuoteRegister To Reply
  5. 07-07-2021, 10:28 AM #5
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Find cell value but cell name or vlookup with cell name

    That seeems to be a bit of cumbersome way of doing things... It must take AGES to name those cells. However...

    =INDIRECT(F2)

    copied down does what you want. However, with a bit more detail provided there WILL be a better way.
    Reply With QuoteRegister To Reply
  6. 07-07-2021, 10:59 AM #6
    ELFIJKA
    ELFIJKA is offline
    Registered User
    Join Date
    10-04-2017
    Location
    Dublin
    MS-Off Ver
    Microsoft 365 Apps for Enterprise
    Posts
    34

    Re: Find cell value but cell name or vlookup with cell name

    We only need to name those cells once, so that doesn't worry my as much. But the benefit of the formula you suggested in massive! Thank you very much for that!
    Reply With QuoteRegister To Reply
  7. 07-07-2021, 11:04 AM #7
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Find cell value but cell name or vlookup with cell name

    The only disadvantage of INDIRECT is thta it is volatile. It will recalculate every time anything changes. On BIG sheets that can (does) cause performance issues. However, if your dataset isn't massive... it should do OK.

    You're welcome.


    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  8. 07-13-2021, 09:35 AM #8
    ELFIJKA
    ELFIJKA is offline
    Registered User
    Join Date
    10-04-2017
    Location
    Dublin
    MS-Off Ver
    Microsoft 365 Apps for Enterprise
    Posts
    34

    Re: Find cell value but cell name or vlookup with cell name

    Sorry but looks like I have issue with INDIRECT formula...
    I'm getting lots of "Volatile" errors. Any suggestions?
    Reply With QuoteRegister To Reply
  9. 07-13-2021, 09:45 AM #9
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,063

    Re: Find cell value but cell name or vlookup with cell name

    You cannot say that you were not warned!!

    However, unless we can SEE what you mean we can diagnose NOTHING. Ye cannot get crystal balls up here for love nor money, thanks to Brexit &/or Covid-19
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert Find Parent Cell Macro to Find Dependent Cell
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-06-2016, 07:30 AM
  2. Vlookup formula on duplicates, then find max value in adjacent cell, return adjacent cell
    By comohelp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2015, 05:10 PM
  3. [SOLVED] Find the matching cell or row from VLOOKUP
    By LonesomeJoe in forum Excel General
    Replies: 3
    Last Post: 05-21-2014, 10:10 AM
  4. Vlookup to find and apply URL to a cell
    By trishcollins in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-02-2014, 03:44 PM
  5. Find blank cell, insert formula to find median of above cell range
    By lilyeye in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2013, 11:58 AM
  6. Find cell in an array, and getting returning value of cell adjacent to found cell
    By Zach8384 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2012, 11:38 PM
  7. VLOOKUP works for me when finding exact data in cell, I want to find a phrase in a cell
    By cellgizm in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-26-2012, 02:02 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1