how to do a vlook up between 2 ranges?

[ntudev]

Hello,

I'm trying to do a vlookup so that my my test numbers falls between the  lower and higher scales to get the results. I attached a spreadsheet for your reference. Can someone help me get the results on Results tab in green?

[Felipe_Ribeir0 · Accepted solution]

Hi @ntudev 

One way of doing this

[binuacs]

@ntudev One way of doing this with the generate record tool