Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

That is the current VLOOKUP in the spreadsheet that is returning the wrong data. I didn't write it, it was on a spreadsheet before I came to the company.

What I want to happen is look up the value in $N101 then I want it to find the row that is the same from i30 to i40 take whats in ((k30-j30/)/(1-(U$96+U$98)) when I say k30 I actually mean k30-k40 depending on the match.

share|improve this question
it is not clear from your description. Is the value in N101 findable in column I? if so, can't the lookup range only be I30:K40, then return column 3? Perhaps a sample would help us visualize what you have. Or maybe using the INDEX function is more suitable – datatoo Jun 1 '11 at 18:25
up vote 0 down vote accepted
share|improve this answer
this was the solution for you? – datatoo Jun 4 '11 at 13:26
@datatoo, it wasn't my question, I was just the editor. bugz will have to decide if it was the solution. – Lance Roberts Jun 4 '11 at 17:19
@bugz was Lance Roberts solution correct for you? The formula appears correct – datatoo Jun 4 '11 at 17:22
sorry I looked at you having edited the question rather than the original submit. – datatoo Jun 4 '11 at 17:24

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .