**Question description:**

*This user has given permission to use the problem statement for this blog.*

I have a column of data lets say in P:P, I used the formula =LOOKUP(2,1/(NOT(ISBLANK(P:P))),P:P) to return the last value in this data. However now I need another formula to return another value from the same selection that is not the result of the above formula. Do you know if I can do this via formulas?

Solved by C. J. in 21 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
02/05/2018 - 08:00

Hi…Welcome to Got It Pro

User
02/05/2018 - 08:00

Hi there

Excelchat Expert
02/05/2018 - 08:01

Could you please share the data?

User
02/05/2018 - 08:01

okay I can create a quick simulation and send now

Excelchat Expert
02/05/2018 - 08:01

sure

Excelchat Expert
02/05/2018 - 08:02

You can also do a demo in this blank sheet at the right

User
02/05/2018 - 08:03

hmmm I expected this to give me 10

User
02/05/2018 - 08:04

I am not sure why this is not giving me the last result in this range now

User
02/05/2018 - 08:04

it works in my personal data on excel 16

Excelchat Expert
02/05/2018 - 08:05

let me check

Excelchat Expert
02/05/2018 - 08:08

ok...google sheet has a little different logic

Excelchat Expert
02/05/2018 - 08:08

otherwise your formula is correct

Excelchat Expert
02/05/2018 - 08:09

You see now it works

User
02/05/2018 - 08:09

Okay well my issue is, when this formula works, I need another cell the then scan A:A again, and return the last value that is not the result in C!

User
02/05/2018 - 08:10

Ah yes I see now. So I need a formula in C2 that does as I said above

User
02/05/2018 - 08:10

I am not sure how to create that using lookup

Excelchat Expert
02/05/2018 - 08:11

so are you saying you want to return the last but one value with another formula?

User
02/05/2018 - 08:12

I want a formula in cell C", that looks at A:A and returns the last value that is not the value in C1 if this makes sense

User
02/05/2018 - 08:12

C2

Excelchat Expert
02/05/2018 - 08:13

so you want 10 in C2, as per your example

User
02/05/2018 - 08:13

Exactly :)

Excelchat Expert
02/05/2018 - 08:19

please check now

Excelchat Expert
02/05/2018 - 08:19

this is a simpler formula than the lookup

Excelchat Expert
02/05/2018 - 08:20

Does that solve your query?

User
02/05/2018 - 08:20

Yes this looks perfect!

User
02/05/2018 - 08:20

Thank you so much for your help

Excelchat Expert
02/05/2018 - 08:20

Is there anything else I can help you with this query?

User
02/05/2018 - 08:20

No this is all thank you and again thank you for your help

Excelchat Expert
02/05/2018 - 08:21

Please do give me a good feedback for my service.

Excelchat Expert
02/05/2018 - 08:21

Thanks for your time. Please do come back for any new question. Have a great day ahead!

User
02/05/2018 - 08:21

I definitely shall and have a good day also

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*