need help with excel vlookup

=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 wro开发者_开发百科ng data. I didnt 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.

This would really help me out

Try

=IF(N101<>"",ROUND(VLOOKUP($N101,$I$30:$U$39,#COL,FALSE)/(1-(U$96+U$98)),0),0)

where #COL is the integer that corresponds to the column containing the resulting value from K$30-J$30 (for example).

VLOOKUP($N101,$I$30:$U$39,12,FALSE)

you say i30 to i 40 but you have mentioned I30 to U39. you might want to change that.

k30 i actually mean k30-k40 depending on the match.

if you mean when you put same formula on below cell then, when you drag this you'll get them automatically. Please check j30, you might want to make j$30$ if you want to always use J30.

I would also suggest checking each of the formula separately and then combine it.