vlookup result is from a formula calculating from another cell

**jaymoore** · 06-03-2017, 02:01 PM

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.

**6StringJazzer** · 06-03-2017, 02:14 PM

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:

Please Login or Register  to view this content.

**jaymoore** · 06-03-2017, 06:02 PM

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.