Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
=IF(N101<>"",ROUND(VLOOKUP($N101,$I$30:$U$39,12,FALSE)/(1-(U$96+U$98)),0),0)

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
3  
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

1 Answer 1

up vote 0 down vote accepted
=IF(N101<>"",ROUND((VLOOKUP($N101,$I$30:$U$40,3,FALSE)-
                    VLOOKUP($N101,$I$30:$U$40,4,FALSE))/(1-(U$96+U$98)),0),0)
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.