#### snoozee

##### New Member
Hi

Can someone please help me with a formula that I can use to achieve the following result.

A value of 1-5 in cell ref C21

In cell ref C19 I have a value that is driven by the user e.g. 4

In cell ref T4:X4 I have the numbers 1 -5 as a heading
In cell ref T5:X5 I have the numbers 2.62, 2.94, 3.27, 3.60 & 3.92

What I need to happen is that the value of C19 is compared against cell ref T5:X5 and depending on the value it will then return a value of 1-5 (cell ref T4:X4 ), so in the example above the value of C21 would be 5 as C19 (4) is greater than "X5" (3.92).

If C19 was 3 then C21 would be 2 or another example if C19 was 1 then C21 would be 1.

if you haven't already guessed it's for target tracking

Hopefully the above makes sense as I'd really appreciate some help.

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Try:
Remove the space after "< "

Code:
``=IF(C19< T5,T4,LOOKUP(C19,\$T\$5:\$X\$5,\$T\$4:\$X\$4))``

Last edited:
Try:
Remove the space after "< "

Code:
``=IF(C19< T5,T4,LOOKUP(C19,\$T\$5:\$X\$5,\$T\$4:\$X\$4))``

Thanks heaps, you're a gem

Replies
2
Views
438
Replies
30
Views
2K
Replies
1
Views
693
Replies
6
Views
384
Replies
1
Views
317

1,196,408
Messages
6,015,102
Members
441,870
Latest member
kojack

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back