How to use VLOOKUP for a ranges of values in an equation

I need to calculate the Root Mean Square Deviation for various ranges of values. In the basic spreadsheet I attached, there are two sheets, DATA and ANALYSIS. DATA contains two columns (spectroscopic data, wavenumbers and absorbances in Columns 1 and 2) and has >17,000 rows. In ANALYSIS I have a set of rows with Upper and Lower Wavenumber columns. I need to calculate the RMS Deviation for the absorbance values in the range between the Upper and Lower Wavenumbers using the equation:
=SQRT(DEVSQ(a:b)/COUNTA(a:b))
where a and b are the absorbances at the Upper/Lower Wavenumbers. I tried the following equation to calculate it:

=SQRT(DEVSQ(VLOOKUP(B2,Data!A2:B17010,2,TRUE):VLOOKUP(c2,Data!A2:B17010,2,TRUE))/COUNTA(LOOKUP(B2,Data!A2:B17010,2,TRUE):VLOOKUP(c2,Data!A2:B17010,2,TRUE))

but it gives an error. Is there a way to use VLOOKUP in an equation like this?

To get you on the right track, this would be the way to sum the values between the specified limits:

=SUM(INDEX(Data!B:B,MATCH(B2,Data!A:A,1)):INDEX(Data!B:B,MATCH(C2,Data!A:A,1)))

that sums the range: Data!B6639:B6665

Using the method I suggested you could use:

=SQRT(DEVSQ(INDEX(Data!B:B,MATCH(B2,Data!A:A,1)):INDEX(Data!B:B,MATCH(C2,Data!A:A,1)))/(MATCH(C2,Data!A:A,1)-MATCH(B2,Data!A:A,1)+1))

which gives a result of: 0.007313

This version gives your expected result of 0.007336

=SQRT(DEVSQ(INDEX(Data!B:B,MATCH(B2,Data!A:A,1)+IF(ISNUMBER(MATCH(B2,Data!A:A,0)),0,1)):INDEX(Data!B:B,MATCH(C2,Data!A:A,1)+IF(ISNUMBER(MATCH(C2,Data!A:A,0)),0,1)))/(MATCH(C2,Data!A:A,1)-MATCH(B2,Data!A:A,1)))