Formula Help - Last Value

[ststern45]

Good day everyone,

I'm looking for a formula that will display the last value (bottom of the cell range) that appears in a range that is the column value.

The values are 0,1,2,3,4,5,6,7,8,9

Values will contain duplicates from 0 through 9 in cell range A1 through last cell containing a value (0 through 9)

For example:

A1 = 9
A2 = 3
A3 = 0
A4 = 2
A5 = 6
A6 = 1
A7 = 4
A8 = 5
A9 = 7
A10 = 8
A11 = 3
A12 = 3
A13 = 5

So in the example above:
B1 = 0
B2 = 1
B3 = 2
B4 = 3
B5 = 4
B6 = 5
B7 = 6
B8 = 7
B9 = 8
B10 = 9

C1 (0) formula = A3 or 3
C2 (1) formula = A6 or 6
C3 (2) formula = A4 or 4
Etc., Etc.

Thank you in advance

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C
1	9	0	3
2	3	1	6
3	0	2	4
4	2	3	12
5	6	4	7
6	1	5	13
7	4	6	5
8	5	7	9
9	7	8	10
10	8	9	1
11	3
12	3
13	5
Main

Cell Formulas
Range	Formula
C1:C10	C1	=LOOKUP(2,1/($A$1:$A$13=B1),ROW($A$1:$A$13))

 

[ststern45]

Thank you Fluff.
Works great.

 

[Fluff]

You're welcome & thanks for the feedback.