Select last number to the far right of a row.

[nparsons75]

Is there a formula that will allow me to select the far most value to the right of a row? Also, the value should only be selected if it appears under the day of the month - 1. (yesterday)

For example, in the top table below the value to the far right = 10 This will be returned in to my result cell as the value does sit under yesterdays day of the month.

In the second example the cell = blank on yesterdays day of month and therefore the result in my result cell will = 0.

I hope this makes sense.....

Book10
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
6	Result	10
7
8	Day of month	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
9	Value	70	61	91	21			73	72	67	116	61			88	103	100	85	69		5	92	107	100	76	62	12	10
Sheet1

Book10
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
14	Result	0
15
16	Day of month	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
17	Value	70	61	91	21			73	72	67	116	61			88	103	100	85	69		5	92	107	100	76	62	12
Sheet1

 

[Fluff]

do the product names need to match exactly

Yes they do, otherwise you can get rid of the match & use the formula from post#10, changing the 2 to reflect the row you want to return the value from.

 

[nparsons75]

Thank you 'fluff' for all your help and patience with me on this....working perfect now.....Really appreciate yuor support...

 

[Fluff]

Glad to help & thanks for the feedback.