# Offset

#### jjdwhitfield

##### Board Regular
All

I hope you can help

I have a fomula in Cell E27 that returns the last value in a column on another tab which is a percentage

=LOOKUP(9.99999999E+307,'SUMMARY MONTHLY STATS'!C6:C59)

In the cell next to it I want to return the character in the column next to it. I have tried the below but it is not working any ideas?

=OFFSET(LOOKUP(9.99999999E+307,'SUMMARY MONTHLY STATS'!C7:C59),,1)

Kind Regards

Jon Whitfield

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### Domenic

##### MrExcel MVP
Try...

=OFFSET(INDEX('SUMMARY MONTHLY STATS'!C6:C59,MATCH(9.99999999999999E+307,'SUMMARY MONTHLY STATS'!C6:C59)),,1)

However, the following can be used instead...

=LOOKUP(9.99999999999999E+307,'SUMMARY MONTHLY STATS'!C6:C59,'SUMMARY MONTHLY STATS'!D6:D59)

Hope this helps!

Thank you!!

Replies
2
Views
115
Replies
0
Views
192
Replies
3
Views
234
Replies
1
Views
195
Replies
6
Views
193

1,195,974
Messages
6,012,627
Members
441,715
Latest member
TTP

### 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