Hi Guys,
In the example I have attached. I have the value 2, I need to look along that row to find the first value that it finds that sits between a range (in this case between 60 & 70, target 62). I then need it to return the green 00 number at the top of that column
I'm using VLOOKUP(D18,A6:L15,2,FALSE) but instead of the 2 I need it to find the first number to the right that sits within a range (between 60&70) and then somehow return the green 00 number in the row above the target
My ultimate aim is to return 006 (G2)
I'm a new member so thanks in advance to anyone that can help.
Cully.
In the example I have attached. I have the value 2, I need to look along that row to find the first value that it finds that sits between a range (in this case between 60 & 70, target 62). I then need it to return the green 00 number at the top of that column
I'm using VLOOKUP(D18,A6:L15,2,FALSE) but instead of the 2 I need it to find the first number to the right that sits within a range (between 60&70) and then somehow return the green 00 number in the row above the target
My ultimate aim is to return 006 (G2)
I'm a new member so thanks in advance to anyone that can help.
Cully.