+ Reply to Thread
Results 1 to 4 of 4

vlookup result is from a formula calculating from another cell

  1. #1
    Forum Contributor
    Join Date
    08-12-2013
    Location
    vancouver
    MS-Off Ver
    Excel 2010
    Posts
    106

    Question vlookup result is from a formula calculating from another cell

    I have a vlookup that should be resulting in a value, but that value is actually the answer to a calculation referencing other cells.

    =VLOOKUP(A41,H37:J85,2,TRUE)

    the values in columns H,I are formulas calculating percentages from two other cells.

    H37=P37/P$86
    I37=M37/M$86
    J37 has the value that matches the vlookup A41

    If I change the range to a cell where it is just the value then it works :-/ =VLOOKUP(A41,J37:M85,1,TRUE), but it is not the value I actually want reported. I need to get the value from the ones computing values.

    Any help is greatly appreciated, thanks.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    23,842

    Re: vlookup result is from a formula calculating from another cell

    Your description of what you actually want to happen is a little muddy but it sounds like you have one of two problems:

    The way your formula works is that it will look for the value in A41 in the range H37:H35. Whatever row it finds that value in, it will return the value from column I in the same row. You have specified a column of "2" which means it starts counting in column H, returning the value from column I. So maybe you meant 3 instead of 2.

    Also, VLOOKUP looks for the value only in the first column of the range--column H in this case. Maybe what you want is to find A41 in column J, and then return H and/or I from that row. This cannot be done with VLOOKUP, which works only from left to right. To take a value from A41 and find it in column J, then return the value in column H in that same row, try this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    08-12-2013
    Location
    vancouver
    MS-Off Ver
    Excel 2010
    Posts
    106

    Re: vlookup result is from a formula calculating from another cell

    6String, thanks for the suggestion. I believe the issue is me wanting to grab the values to the LEFT of the vlookup match.

    Your suggestion worked. Thank you very much.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Office 2010
    Posts
    27,167

    Re: vlookup result is from a formula calculating from another cell

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. VBA Vlookup to input result(formula) into a cell
    By Ksharpes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2015, 12:04 PM
  2. [SOLVED] How to use a VLOOKUP to take formula rather than result of target cell
    By chris01252 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-20-2014, 12:42 PM
  3. Formula in cell to result in a 1-5 score via Vlookup
    By jamietofs in forum Excel General
    Replies: 4
    Last Post: 12-12-2012, 12:58 AM
  4. [SOLVED] Returning the cell above a vlookup formula result
    By mike_vr in forum Excel General
    Replies: 3
    Last Post: 05-16-2012, 07:34 AM
  5. Need to have Vlookup to pull the result of a cell instead of the formula in it
    By JESSIER4025 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2012, 10:03 AM
  6. [SOLVED] Vlookup is displaying the formula in its cell not the result??
    By Craig H in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2006, 06:15 AM
  7. [SOLVED] VLOOKUP formula appears in the cell I need to see the result in
    By Shaynes in forum Excel General
    Replies: 3
    Last Post: 05-11-2005, 07:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1