Retrieve last value in a row range

[Nicole Jones]

Hi there,

Is there a way to return a the value of a row (portion of the row) that also contains blank cells.

E.g. the row may contain the following cells

A​	B​	C​	D​	E​	F​	G​	H​	I​	J​
02/04/2023​	​	​	07/06/2023​	​	​	​	15/08/2023​	​	​

I am chasing a formula to return the column H value, not sure if this is possible with empty cells.

Any help is appreciated, thank you in advance.

 

[Phuoc]

Try this:

=LOOKUP(100000,A2:H2)

 

[Nicole Jones]

Try this:

=LOOKUP(100000,A2:H2)

Phuoc, you are a champion.
Thank you

 

[Nicole Jones]

Try this:

=LOOKUP(100000,A2:H2)

Apologies Phuoc,

This worked until I formatted the table, now that it is a table it doesn't like this formula

Any ideas?

 

[MARK858]

Works fine for me in a Table (are you sure your dates are still real dates and not text?)

Book1.xlsb
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8	Column 9	Column 10	Column 11	Column 12	Column 13	Column 14
2	02/04/2023			07/06/2023				15/08/2023						15/08/2023
3	11/04/2023			16/06/2023				24/08/2023						24/08/2023
4	03/04/2023			08/06/2023				16/08/2023						16/08/2023
5	12/04/2023			17/06/2023				25/08/2023						25/08/2023
6	04/04/2023			09/06/2023				17/08/2023						17/08/2023
7	13/04/2023			18/06/2023				26/08/2023						26/08/2023
8	05/04/2023			10/06/2023				18/08/2023						18/08/2023
9	14/04/2023			19/06/2023				27/08/2023						27/08/2023
10	06/04/2023			11/06/2023				19/08/2023						19/08/2023
11	15/04/2023			20/06/2023				28/08/2023						28/08/2023
12	07/04/2023			12/06/2023				20/08/2023						20/08/2023
13	16/04/2023			21/06/2023				29/08/2023						29/08/2023
14	08/04/2023			13/06/2023				21/08/2023						21/08/2023
15	17/04/2023			22/06/2023				30/08/2023						30/08/2023
Sheet3

Cell Formulas
Range	Formula
N2:N15	N2	=LOOKUP(100000,A2:M2)